Description
To create an event procedure that runs when the Print event occurs, set the OnPrint property to [Event Procedure], and click the Build button.
Syntax Private Sub sectionname_Print(Cancel As Integer, PrintCount As Integer) The Print event procedure has the following arguments.| Argument | Description |
| sectionname | The name of the report section whose Print event procedure you want to run. |
| Cancel | The setting determines if the printing of the section occurs. Setting the Cancel argument to True (–1) cancels printing of the section. |
| PrintCount | An Integer value that specifies 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 Microsoft Access sets the PrintCount argument to 2. |
Remarks To cancel printing of the section, you should set the Cancel argument to True (–1) or use the CancelEvent method of the DoCmd object. Microsoft Access prints a blank area on the page where the section would have been. You can use the CancelEvent method or the Cancel argument to skip a record in a report and leave a blank area on the page in its place when the report is printed.
Note You can't use a Print event procedure to set properties for any object.See Also Print event — macros.
Example The following example checks the PrintCount argument to determine the number of times the Print event has occurred. If it has occurred more than once, the Print event is canceled for the section. To try the example, add the following event procedure to a report that contains a section named CustomerDetail.Private Sub CustomerDetail_Print(Cancel As Integer, _
PrintCount As Integer)
If PrintCount > 1 Then Cancel = True
End Sub