Error during display for no rows

  • Thread starter Thread starter Yorkie
  • Start date Start date
Y

Yorkie

When you preview a report based on a query that returns no
rows the report displays "Error!"

How can I get it to not display "Error", but to display
something more friendly like "No rows returned" or even
just to leave the detail section blank (so the user won't
think the report is broken).

Thank you.
Y
 
You probably have a calculated value that depends on having records in the
report. You can replace your expression with:
=IIf(HasData,[YourExpression],"No rows Returned")
 
Thanks - that was it!
-----Original Message-----
You probably have a calculated value that depends on having records in the
report. You can replace your expression with:
=IIf(HasData,[YourExpression],"No rows Returned")

--
Duane Hookom
MS Access MVP


When you preview a report based on a query that returns no
rows the report displays "Error!"

How can I get it to not display "Error", but to display
something more friendly like "No rows returned" or even
just to leave the detail section blank (so the user won't
think the report is broken).

Thank you.
Y
Click to expand...


.
Click to expand...
 
Back
Top