Report Events (Access)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

This object has the following events:

Events

Name

Description

Activate

The Activate event occurs when a report receives the focus and becomes the active window.

ApplyFilter

Occurs when a filter is applied to a report.

Click

The Click event occurs when the user presses and then releases a mouse button over a report.

Close

The Close event occurs when a report is closed and removed from the screen.

Current

Occurs when the focus moves to a record, making it the current record, or when the report is refreshed or requeried.

DblClick

The DblClick event occurs when the user presses and releases the left mouse button twice over an report within the double-click time limit of the system.

Deactivate

The Deactivate event occurs when a report loses the focus to a Table, Query, Form, Report, Macro, or Module window, or to the Database window.

Error

The Error event occurs when a run-time error is produced in Microsoft Access when a report has the focus.

Filter

Occurs when the user opens a filter window by clicking Advanced Filter/Sort.

GotFocus

The GotFocus event occurs when the report receives the focus.

KeyDown

The KeyDown event occurs when the user presses a key while a report has the focus. This event also occurs if you send a keystroke to a report by using the SendKeys action in a macro or the SendKeys statement in Visual Basic.

KeyPress

The KeyPress event occurs when the user presses and releases a key or key combination that corresponds to an ANSI code while a report has the focus. This event also occurs if you send an ANSI keystroke to a report by using the SendKeys action in a macro or the SendKeys statement in Visual Basic.

KeyUp

The KeyUp event occurs when the user releases a key while a report has the focus. This event also occurs if you send a keystroke to a report by using the SendKeys action in a macro or the SendKeys statement in Visual Basic.

Load

Occurs when a report is opened and its records are displayed.

LostFocus

The LostFocus event occurs when the specified object loses the focus.

MouseDown

The MouseDown event occurs when the user presses a mouse button.

MouseMove

The MouseMove event occurs when the user moves the mouse.

MouseUp

The MouseUp event occurs when the user releases a mouse button.

MouseWheel

Occurs when the user rolls the mouse wheel in Report view or Layout view.

NoData

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.

Open

The Open occurs before a report is previewed or printed.

Page

The Page event occurs after Microsoft Access formats a page of a report for printing, but before the page is printed. You can use this event to draw a border around the page, or add other graphic elements to the page.

Resize

The Resize event occurs when a report is opened and whenever the size of a report changes.

Timer

The Timer event occurs for a report at regular intervals as specified by the report's TimerInterval property.

Unload

The Unload event occurs after a report is closed but before it's removed from the screen.