This documentation is archived and is not being maintained.

FormatCondition Object [Access 2003 VBA Language Reference]

Office 2003

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.

Parent Objects

Child Objects