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.

PropertyData TypeDescription
ApplicationApplication objectReturns the currently active Application object
ColumnVariantUsed to refer to a specific column in a combo box or list box
ControlsControls collectionUsed to refer to the collection of all the controls on the form
FormForm objectRefers to the current form object
HyperlinkHyperlink objectUsed to access the properties and methods of a hyperlink object associated with a control
ItemDataVariantReturns the data in the bound column for the specified row in a combo box or list box
ItemsSelectedItemsSelected collectionReturns a reference to the ItemsSelected collection
ObjectActiveX objectReturns a reference to the ActiveX object associated with a linked or embedded OLE object in a control
ObjectVerbsStringUsed to determine the list of verbs an OLE object supports
OldValueVariantUsed to determine the unedited value of a bound control
PagesIntegerReturns the number of pages in a control that supports tabbed pages
ParentVariousFor controls, usually a form object
PropertiesProperties collectionReturns a reference to the entire collection of properties for the object
ReportReport objectRefers 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.