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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf + Null value + #Error 4
Displaying blank space when no data in subreport 5
More summing problems 2
SynNeed to account for null values in subreports 2
Access How to prevent subReport from breaking across pages? 1
displaying the combined value of a subreport and a field 2
Subreport with no records 8
Transferring sum from subreport to main report 2

Back
Top