E.15. The Control Object
Within a form, you can have a variety of different controls. You use the controls to display data from tables, queries, and other data sources such as ADO recordsets.
E.15.1. Control Properties
The Control object has a variety of properties found in the following table.
Property | Data Type | Description |
---|---|---|
Application | Application object | Returns the currently active Application object |
Column | Variant | Used to refer to a specific column in a combo box or list box |
Controls | Controls collection | Used to refer to the collection of all the controls on the form |
Form | Form object | Refers to the current form object |
Hyperlink | Hyperlink object | Used to access the properties and methods of a hyperlink object associated with a control |
ItemData | Variant | Returns the data in the bound column for the specified row in a combo box or list box |
ItemsSelected | ItemsSelected collection | Returns a reference to the ItemsSelected collection |
Object | ActiveX object | Returns a reference to the ActiveX object associated with a linked or embedded OLE object in a control |
ObjectVerbs | String | Used to determine the list of verbs an OLE object supports |
OldValue | Variant | Used to determine the unedited value of a bound control |
Pages | Integer | Returns the number of pages in a control that supports tabbed pages |
Parent | Various | For controls, usually a form object |
Properties | Properties collection | Returns a reference to the entire collection of properties for the object |
Report | Report object | Refers to a report or the report associated with a subreport control ... |
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.