This documentation is archived and is not being maintained.

Report Object [Access 2003 VBA Language Reference]

Office 2003
Multiple objects
Report
Multiple objects

A Report object refers to a particular Microsoft Access report.

Using the Report Object

A Report object is a member of the Reports collection, which is a collection of all currently open reports. Within the Reports collection, individual reports are indexed beginning with zero. You can refer to an individual Report object in the Reports collection either by referring to the report by name, or by referring to its index within the collection. If the report name includes a space, the name must be surrounded by brackets ([ ]).

Syntax Example
Reports!reportname Reports!OrderReport
Reports![report name] Reports![Order Report]
Reports("reportname") Reports("OrderReport")
Reports(index) Reports(0)

Note  Each Report object has a Controls collection, which contains all controls on the report. You can refer to a control on a report either by implicitly or explicitly referring to the Controls collection. Your code will be faster if you refer to the Controls collection implicitly. The following examples show two of the ways you might refer to a control named NewData on a report called OrderReport.

' Implicit reference.
Reports!OrderReport!NewData
		
' Explicit reference.
Reports!OrderReport.Controls!NewData
		


Properties | ActiveControl Property | AutoCenter Property | AutoResize Property | BorderStyle Property | Caption Property | CloseButton Property | ControlBox Property | Controls Property | Count Property | CurrentRecord Property | CurrentX Property | CurrentY Property | DateGrouping Property | DefaultControl Property | Dirty Property | DrawMode Property | DrawStyle Property | DrawWidth Property | FastLaserPrinting Property | FillColor Property | FillStyle Property | Filter Property | FilterOn Property | FontBold Property | FontItalic Property | FontName Property | FontSize Property | FontUnderline Property | ForeColor Property | FormatCount Property | GridX Property | GridY Property | GroupLevel Property | GrpKeepTogether Property | HasData Property | HasModule Property | Height Property | HelpContextId Property | HelpFile Property | Hwnd Property | InputParameters Property | LayoutForPrint Property | Left Property | MenuBar Property | MinMaxButtons Property | Modal Property | Module Property | Moveable Property | MoveLayout Property | Name Property | NextRecord Property | ObjectPalette Property | OnActivate Property | OnClose Property | OnDeactivate Property | OnError Property | OnMenu Property | OnNoData Property | OnOpen Property | OnPage Property | OpenArgs Property | OrderBy Property | OrderByOn Property | Orientation Property | Page Property | PageFooter Property | PageHeader Property | Pages Property | Painting Property | PaintPalette Property | PaletteSource Property | Picture Property | PictureAlignment Property | PictureData Property | PicturePages Property | PictureSizeMode Property | PictureTiling Property | PictureType Property | PopUp Property | PrintCount Property | Printer Property | PrintSection Property | Properties Property | PrtDevMode Property | PrtDevNames Property | PrtMip Property | RecordLocks Property | Recordset Property | RecordSource Property | RecordSourceQualifier Property | Report Property | ScaleHeight Property | ScaleLeft Property | ScaleMode Property | ScaleTop Property | ScaleWidth Property | Section Property | ServerFilter Property | Shape Property | ShortcutMenuBar Property | Tag Property | Toolbar Property | Top Property | UseDefaultPrinter Property | Visible Property | Width Property | WindowHeight Property | WindowLeft Property | WindowTop Property | WindowWidth Property



Show: