Can I suppress...

[Guest]

....a field in a report if there is no data in that particular cell?

I have a report in which I wish to include comments ONLY if there IS a
comment in the query on which the report is based. Some cells will not have a
comment.

Can I suppress blank fields to minimize blank spaces?

Thanks.

 

[Allen Browne]

If the Comments text box is on a line of its own in the report, just set its
CanShrink property to Yes. The CanShrink property of the (Detail?) section
will also be set to Yes.

If the text box has an attached label and you want to hide that label too,
right-click it (in report design view), and choose:
Change To | Text box
Then set the Control Source of this text box to something like this:
=IIf([Comments] Is Null, Null, "Comments:")