The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

ActiveReport Property [Access 2003 VBA Language Reference]

Office 2003

You can use the ActiveReport property together with the Screen object to identify or refer to the report that has the focus. Read-only Report object.


expression Required. An expression that returns one of the objects in the Applies To list.


This property setting contains a reference to the Report object that has the focus at run time.

This property is available only by using a macro or Visual Basic and is read-only in all views.


You can use the ActiveReport property to refer to an active report together with one of its properties or methods. The following example displays the Name property setting of the active report.

Dim rptCurrentReport As Report
Set rptCurrentReport = Screen.ActiveReport
MsgBox "Current report is " & rptCurrentReport.Name

If no report has the focus when you use the ActiveReport property, an error occurs.

Applies to | Screen Object