Formatting Mailing Addresses

[Caroselle]

Hello,

I've searched the forum, but I can't find exactly what I'm looking for. On
an invoice, I have the addresses broken out in separate fields: Name,
Address1, Address2, Address3, City, State, Zip, Country. Not all addresses
have all three lines of the address filled. So for example, I might get the
following:

Name
Address1


City, State Zip
Country

I've tried using the Can Shrink on Address2 and Address3, but it doesn't
move the other fields up to fill in the blank space.

I've also tried using the expression builder to put all the data pieces into
one field, forcing line breaks using chr(13) & chr(10). I then changed that
field's Can Shrink property to yes. But it still left blank lines in there.

Any other suggestions?

Thank you very much!

 

[Rick B]

You need to make each control only one pixel in height, then set each
control's CAN GROW to true.

Not sure if this is the best way, but I know it works!