Screen.ActiveReport property (Access)

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.

Syntax

expression.ActiveReport

expression A variable that represents a Screen object.

Remarks

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

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.