E.20. The Reports Collection and Report Object
Microsoft Access contains a Reports collection that contains a Report object for every report within your database.
E.20.1. Properties of the Report Object
The properties of the Report object are listed in the following table.
|ActiveControl||Control object||Used with the Screen object to determine the control that has the focus|
|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||Used to identify the current record being viewed on a report|
|CurrentX||Single||Used to specify the horizontal coordinates for the starting position of the next printing and drawing method on a report|
|CurrentY||Single||Used to specify the vertical coordinates for the starting position of the next printing and drawing method on a report|
Get Access 2003 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.