Report Text box visible

  • Thread starter Thread starter A Hopper
  • Start date Start date
A

A Hopper

In the Report Header section of my report "Job Performance
Roll Card", I have a text box named "PassNumber" . The
report is opened and printed from a Dialog Box "Print Job
Performance" that has a text box named "PassNumber". If
the Dialog Box "PassNumber" is Null then I want the text
box on the report to be invisible and/or not to print. Is
this possible?

Thanks for your help.

Allan
 
You could try an expression like:
=IIf(IsNull(Forms!frmDialog!PassNumber),"","Something Else")
 
Duane, I am not certain where I should put the expression.
Does this make the text box invisible or not print?
Thanks
Allan
 
Use it as the Control Source of the text box. If the text box on the form is
null then the text box on the report will not display anything.
 
Back
Top