Report Object

Article
06/14/2014

Access Developer Reference

A Report object refers to a particular Microsoft Access report.

Remarks

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.

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.

Visual Basic for Applications
`' Implicit reference. Reports!OrderReport!NewData`

Visual Basic for Applications
`' Explicit reference. Reports!OrderReport.Controls!NewData`

Report Object

Additional resources