Hide #Error

  • Thread starter Thread starter jnew
  • Start date Start date
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.
 
Test the HasData property of the report in the subreport control.

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