Print Events

        

Print events occur when a report is being printed or is being formatted for printing.

Event Event property It occurs
Format OnFormat (reports) When Microsoft Access determines which data goes in a report section, but before Microsoft Access formats the section for previewing or printing. Your macro or event procedure can use data in the current record to make changes to the page layout.
NoData OnNoData (reports) 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.
Page OnPage (reports) After Microsoft Access formats a page for printing, but before the page is printed.
Print OnPrint (reports) After Microsoft Access has formatted the data in a report section, but before the section is printed.
Retreat OnRetreat (reports) When Microsoft Access must "back up" past one or more report sections on a page in order to perform multiple formatting passes. This occurs after the section's Format event, but before the Print event. The Retreat event for each section occurs as Microsoft Access backs up past the section. This allows you to undo any changes you have made during the Format event for the section.