Every control on a form or report has dozens of different or settingsso how do you keep them all straight? Table 7-4 shows you howthis lesson is really a cheat sheet that you can use whenever you're not sure what exactly a particular control property is or does. The most important properties are marked with a *.
Table 7-4. Common Form and Report Control Properties
Displays a descriptive caption for a form or text label.
Customizes the way numbers, dates, times, and text are displayed and printed.
Decimal Places *
Determines the number of decimal places displayed.
Shows or hides a control. Useful if you want to use information on the form without it being visible. For example, you could use the value in a hidden control as the criteria for a query.
Determines whether a section or control always appears or only appears when it is displayed on screen or printed.
Determines whether scroll bars appear in the control.
Determines the horizontal position of the control.
Determines the vertical position of the control.
Determines the width of a control.
Determines the height of a control.
Determines whether a control is transparent or not.
Determines the color of a control. Click the button to select a color from a palette.
Applies a 3-D effect to a control.
Determines the line style of a control's borderselect from transparent lines, solid lines, dashed lines, etc.
Determines the color of a control's border. Click the button to select a color from a palette.
Determines the width of a control's border (in points).
Determines the color of text in a control or the fill color of an object. Click the button to select a color from a palette.
Determines the font used in a control (such as Arial or Times New Roman).
Determines the thickness (boldface) of text in a control.
Determines whether the text in a control appears in italics.
Determines whether the text in a control is underlined.
Determines how text should be aligned in a control.
Control Source *
Determines the data that appears in the control.
Input Mask *
Limits the amount and type of information that can be entered in a field, such as (___) ___ _-_____ _ for a phone number. Click the button to create an input mask using the Input Mask Wizard.
Default Value *
Specifies a value that is automatically entered in this field for new records.
Validation Rule *
Allows you to enter an expression that is evaluated when data in the field is added or changed.
Validation Text *
Allows you to enter a message that is displayed when data doesn't meet the Validation Rule property.
Determines whether changes can be made to a field's data.
Allows you to assign a macro or Visual Basic procedure to a specific event, such as when you click or update a control.
Specifies the name of the control that identifies it in expressions, macros, and Visual Basic procedures.
Status Bar Text
Specifies a message to display in the Status bar when the control is selected.
Enter Key Behavior
Determines if pressing the Enter key adds a new line of text in a control or if it moves to the next field.
Determines if AutoCorrect (i.e., "teh" "the) is used in a control.
Used with the Input Mask property. Determines whether an automatic tab to the next field occurs when the last character permitted by a text box control's input mask is entered.
Determines whether users are able to tab to the control.
Determines the tab order.
Shortcut Menu Bar
Specifies a user-created shortcut menu that appears when the control is right-clicked.
Specifies a brief message that appears when a user points at the control for a couple of seconds.
Help Context Id
Specifies an identifier number for a user-created Help file that appears when the user selects the control and presses F1.
Specifies extra, user-defined information that is stored in the object.