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.

PropertyData TypeDescription
ActiveControlControl objectUsed with the Screen object to determine the control that has the focus
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
CurrentRecordLongUsed to identify the current record being viewed on a report
CurrentXSingleUsed to specify the horizontal coordinates for the starting position of the next printing and drawing method on a report
CurrentYSingleUsed to specify the vertical coordinates for the starting position of the next printing and drawing method on a report
DateGrouping ...

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.