AnsweredAssumed Answered

conditional formula - not working when printing mailing labels

Question asked by JackHaggerty on Dec 18, 2014
Latest reply on Dec 18, 2014 by philmodjunk

Title

conditional formula - not working when printing mailing labels

Post

When printing my Christmas list data base has the following fields: FirstName, SpouseName, LastName, etc.  
Suppose FirstName contains "John" and SpouseName contains "Mary" and LastName Contains "Smith.
My goal is to print on the label: John & Mary Smith,  i.e to add the "&" character whenever the SpouseName field has data.
This is my conditional formula for the SpouseName field which fails to add the "&" Character:
If ( (IsEmpty(self) ); Self; "\&" & Self)
What gets printed is: John Mary Smith.  The "&" doesn't get printed.  
I am using FileMaker Pro 13.  Since I am a new user, I suspect the problem is mine and not the FileMaker product.
 

 

 

Outcomes