Removing blank fields from addresses on letters

[Kevin Cheesman]

Empty fields show as blank lines in addresses on letters. I know how to remove these in Access, which is by creating a field with IIf's and isnull's around the address fields.

How do I do this in FileMaker?

[aaa]

Hi, Kevin!

IsEmpty() function not help?

[IdealData]

Check out "sliding" in the FMP7 Help system

[SlimJim]

Do the same thing as you do in Access with appropriate changes to reflect the function names in Filemaker.

For example suppose you have fields Name, Address1, Address2, City, PostalCode then define an unstored calculation field

EnvelopeAddress =

Name & "¶" & If(IsEmpty(Address1);"";Address1 & "¶") & If(IsEmpty(Address2);"";Address2 & "¶") & City & "¶" & PostalCode

I'm assuming Name City and PostalCode are not empty but if they could be do the same calculation for all address lines.

[Ender]

Or use merge fields.