Print Event — Macros
Description
To run a macro when the Print event occurs, set the OnPrint property to the name of the macro.
Remarks
You can use the PrintCount property to check whether the Print event has occurred more than once for a record. For example, if part of a record is printed on one page and the rest is printed on the next page, the Print event occurs twice, and the PrintCount property is set to 2. You can check the PrintCount property value for Print macros that should run only once for a record, such as a macro that shows totals for the records on a page in a page footer.
You can use the CancelEvent action in a Print macro to cancel printing of a section. Microsoft Access prints a blank area on the page where the section would have been when the report is printed. You can use the CancelEvent action to skip a record in a report and leave a blank area on the page in its place when the report is printed.
A Print macro runs only for sections that are actually printed.
Note You can't use a Print macro to set properties for any object.
See Also
Print event — event procedures, PrintCount property.