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.
| Property | Data Type | Description |
|---|---|---|
| ActiveControl | Control object | Used with the Screen object to determine the control that has the focus. |
| AllowLayoutView | Boolean | Determines whether a report can be viewed in Layout view. |
| AllowReportView | Boolean | Determines whether a report can be viewed in report view. |
| Application | Application object | Returns the currently active application object. |
| AutoCenter | Boolean | Determines whether the report will be automatically centered within the Application window. |
| AutoResize | Boolean | Determines whether the report will be automatically resized to display complete records. |
| BorderStyle | Byte | Specifies the type of border and border elements for the report. |
| Caption | String | Specifies the caption in the title bar for the report. |
| CloseButton | Boolean | Specifies whether the Close button on a report is enabled. |
| ControlBox | Boolean | Specifies whether the form has a control menu (in Form and Datasheet view only). |
| Controls | Controls collection | Specifies the collection of all controls on the report. |
| Count | Integer | Specifies the number of items within the Reports collection. |
| CurrentRecord | Long | Identifies the current record being viewed on a report. |
| CurrentView | Integer | Determines ... |
Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
