FormatCondition Object
Collapse the table of content
Expand the table of content

FormatCondition Object (Access)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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.

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.

© 2015 Microsoft