NoData Event

Applies To

Report.

Description

The NoData event occurs after Microsoft Access formats a report for printing that has no data (the report is bound to an empty recordset), but before the report is printed. You can use this event to cancel printing of a blank report.

Remarks

If the report is not bound to a table or query (using the report’s RecordSource property), the NoData event does not occur.

This event occurs after the Format events for the report, but before the first Print event.

This event does not occur for subreports. If you want to hide controls on a subreport when the subreport has no data, so that the controls don’t print in this case, you can use the HasData property in a macro or event procedure that runs when the Format or Print event occurs.

The NoData event occurs before the first Page event for the report.

See Also

Format Event, HasData Property, Print Event, Retreat Event.