conditional formula - not working when printing mailing labels
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.