Report Text box visible

[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

 

[Duane Hookom]

You could try an expression like:
=IIf(IsNull(Forms!frmDialog!PassNumber),"","Something Else")

 

[A Hopper]

Duane, I am not certain where I should put the expression.
Does this make the text box invisible or not print?
Thanks
Allan

 

[Duane Hookom]

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.