Error during display for no rows

[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

 

[Duane Hookom]

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")

 

[Yorkie]

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

.