Preventing blank fields from printing on report

[pas]

I am new to access and I'm trying to compile a list of names and addresses.
Some have addresses of up to 5 lines, while others only have 3 lines. When
printing the report as a two column list of names and addresses, the
addresses that only have 3 lines also contain 2-3 blank lines where
additional lines of address would go if it had more lines such as company
name, building, etc. Is there a way to have the blank fields not print on my
report so only 3 lines of address show if that's all there is. Thanks.

 

[Allen Browne]

Use the CanShrink property of the text box on the report. If there is
nothing in the text box, it will shrink to zero-height, provided there is
nothing overlapping the text box vertically - not even a label beside it.

Post a followup to this thead if you have problems, with that, or if you
need the label. Use Trim() if you concatenate spaces into the fields, e.g.:
=Trim([City] & " " & [Zip])