hide a label with text

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

Guest

I have a report with a label. Also have a form that builds the report. This
form has an optional text field. If the user leaves the form's text field
blank, I want the report's label to show. If user enters anything in the
text box, I need that to override the label and show the text. Any help is
greatly appreciated!! thanx - David
 
You could try a text box with a control source like:
=Nz(Forms!frmA!txtOptional,"The Caption")
 
Back
Top