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.
