Properties

All forms have a set of properties that are specific to them, and each control (text box, command button, and so on) on the form has its own properties as well. There are many properties that share a common name between a form and the controls contained on it, but each object retains its own values. For example, a form and a text box both have a visible property, but the text box property may be set to False, while the form property is set to True. For review, the following table displays a list of example properties. A longer list can be found in Appendix E.

Object

Property

Description

Form

Caption

A string expression that appears in the title bar of the form

Recordsource

A string expression that defines the source of data

AllowEdits

Boolean value that specifies if the user can edit records on the form

Text box

ControlSource

A string expression identifying the name of the field in the Form's Recordsource that the text box should push/pull data.

Visible

Boolean value that specifies if the control is visible to the user

InputMask

A string expression that defines the way data is entered

StatusBarText

A string expression displayed at the bottom of the Access window while the cursor is in the control

Combo box

RowSource

A string expression that defines the source of data

LimitToList

Boolean value that restricts the user's selection to only values in the combo box

Tab Index

Numerical value that specifies the order in which the cursor should travel from one field to the next

0 0

Post a comment