Wednesday, February 15, 2012

Empty Address Lines

What is an easy way to squeeze the lines of an address when anyone one of the address lines might be empty?

Example:
Customer Name
AddressLine1
AddressLine2
AddressLine3
City, ST, ZIP

I have not tried this but you can try using a formula for the LINE HEIGHT property of the the address lines - Under Properties/Format

=iif(Fields!AddressLine2.Value= "","0pt","9pt")

This hopeful will set it's line height to 0 if its empty OR 9pts if not.

No comments:

Post a Comment