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])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fields not shrinking 5
How do I suppress blank lines in reports 1
Cancel printing blank lines 1
not printing empty fields on labels 1
blank fields on a name line 2
Report Formatting 3
Adding Blank Lines to a Report 0
MS Access Rpt how do you close up a line when the field is empty 1

Back
Top