Showing posts with label squeeze. Show all posts
Showing posts with label squeeze. Show all posts

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.