O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

G.13. The Reports Collection and Report Object

Microsoft Access contains a Reports collection that contains a Report object for every open report within your database. Reports that are not currently open in the database are not in the Reports collection.

G.13.1. Report Object Properties

The properties of the Report object are listed in the following table.

PropertyData TypeDescription
ActiveControlControl objectUsed with the Screen object to determine the control that has the focus.
AllowLayoutViewBooleanDetermines whether a report can be viewed in Layout view.
AllowReportViewBooleanDetermines whether a report can be viewed in report view.
ApplicationApplication objectReturns the currently active application object.
AutoCenterBooleanDetermines whether the report will be automatically centered within the Application window.
AutoResizeBooleanDetermines whether the report will be automatically resized to display complete records.
BorderStyleByteSpecifies the type of border and border elements for the report.
CaptionStringSpecifies the caption in the title bar for the report.
CloseButtonBooleanSpecifies whether the Close button on a report is enabled.
ControlBoxBooleanSpecifies whether the form has a control menu (in Form and Datasheet view only).
ControlsControls collectionSpecifies the collection of all controls on the report.
CountIntegerSpecifies the number of items within the Reports collection.
CurrentRecordLongIdentifies the current record being viewed on a report.
CurrentViewIntegerDetermines ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required