Empty report fields

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

Guest

When printing out a report, how can fields that are empty not be displayed so
you don't have blank spaces on the report
 
You can suppress the vertical space taken up by a text box on a report by
setting Can Shrink to Yes.

This only works if:
a) There is nothing else beside the text box (even partially overlapping it
vertically) that can't shrink - not even a label.

b) The text box contains a Null value (not some spaces or zero-length
strings from concatening fields together.)

To set it up:
1. In report design view, select the text box to shrink.
Set its Can Shrink property to Yes (Format tab of Properties box.)

2. Make sure the Can Shrink property of the section (e.g. Detail) is also
set to Yes.

If you need to suppress the label as well:
3. Right-click the label, and choose Change To | Text Box.

4. Set the Control Source of this text box (the one that was the label) to:
=IIf([AddressLine2] Is Null, Null, "Address Line 2:")
substituting your text box name instead of AddressLine2.
 
Back
Top