O'Reilly logo

Access 2003 VBA Programmer's Reference by Armen Stein, Graham Seach, Teresa Hennig, Patricia Cardoza

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

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 ...

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