Hide #Error

J

jnew

Greetings,

A control on my report captures a value from a subreport.
If the subreport has no data, however, the control
displays #Error. Is there an expression or procedure that
will display a blank (null) instead of the error message?

Any help will be appreciated.
 
A

Allen Browne

Test the HasData property of the report in the subreport control.

=IIf([MySubreport].[Report].[HasData],
Nz([MySubreport].[Report].[MyTextbox], 0), 0)
 
Top