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

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

Guest

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:")
 
Back
Top