2 Replies Latest reply on Dec 18, 2014 6:56 AM by philmodjunk

    conditional formula - not working when printing mailing labels

    JackHaggerty

      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.