Preventing blank fields from printing on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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])
 
Back
Top