How to Display no Records

Guest · Jun 29, 2006

How can I get a message like: No records to display. on a report?

Allen Browne · Jun 29, 2006

Use the NoData event of the report.

If the event fires, pop up a MsgBox.

Guest · Jun 29, 2006

On the On NoData Property of the report write the code

MsgBox "No Data"
Cancel = True