How will you use this "and" text?
Both a calculation field and layout text with custom formatting can be used to make "And" appear or disappear. The best option depends on what you plan to do with this text.
A calculation field:
If ( Not IsEmpty (name ) ; "and" )
or add "and" as layout text to the layout where you want it and use:
IsEmpty ( YourTable::Name )
to set the font size to 500 to keep "and" invisible until there is text in the field.
Make your "and" field a calculation
Case (IsEmpty(name); ""; "and")
This field will be used when formatting address labels and merged letters. For example: if John Smith is married to Sally Smith I would enter "Sally" into field:name and then field:and will fill automatically. Then my label will say John and Sally Smith. Sometimes there is a partner and sometimes not so I'm trying to simplyfy the process of putting the "and" onto the labels.
I'm planning to actually have:
where <partner_full_name> and <and2> are for partners with different last names. When the last name is the same <partner_full_name> is blank and thus so is <and_2> so they don't print. When partner's last name is different <partner_first_name> will be left blank and will not trigger <and> therefore those won't print.
Is this a reasonable way to go about it?
Works great thanks