FormatCondition Object [Access 2003 VBA Language Reference]

FormatConditions FormatCondition

The FormatCondition object represents a conditional format of a combo box or text box control and is a member of the FormatConditions collection.

Using the FormatCondition Object

You can use the FormatConditions(index), where index is the index number of the conditional format, to return a FormatCondition object.

Use the Add method to create a new conditional format. You can use the Modify method to change one of the formats, or the Delete method to delete a format.

Conditional formatting can also be set on a combo box or text box from the Conditional Formatting dialog box. The Conditional Formatting dialog box is available by clicking Conditional Formatting on the Format menu when a form is in Design view.

Use the BackColor , Enabled , FontBold , FontItalic , FontUnderline , and ForeColor properties of the FormatCondition object to control the appearance of formatted combo box and text box controls.

Properties | BackColor Property | Enabled Property | Expression1 Property | Expression2 Property | FontBold Property | FontItalic Property | FontUnderline Property | ForeColor Property | Operator Property | Type Property

Methods | Delete Method | Modify Method

Parent Objects

Child Objects

See Also | FormatConditions Collection