How do make a TextBox not display in an Access report when it is .

I have a report with two TextBoxes that I use to display information from a
table. Often in the report, one or the other (or both) of the controls are
emplty (i.e., no data is returned from the Table. I would like the report
not to display the Label of the TextBox in those situations.

Change the label to a text box (right-click it.)

Put an expression in the Control Source of this text box so it is null when
the main one is null. For example, if you want it to show "City:" only when
the City text box has a value, use:
=IIf([City] Is Null, Null, "City:")

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Larry M" Larry wrote in message
...
I have a report with two TextBoxes that I use to display information from a
table. Often in the report, one or the other (or both) of the controls
are
emplty (i.e., no data is returned from the Table. I would like the report
not to display the Label of the TextBox in those situations.