FormatCondition object (Access)

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

Remarks

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. 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.

Methods

• Delete
• Modify

Properties

• BackColor
• Enabled
• Expression1
• Expression2
• FontBold
• FontItalic
• FontUnderline
• ForeColor
• LongestBarLimit
• LongestBarValue
• Operator
• ShortestBarLimit
• ShortestBarValue
• ShowBarOnly
• Type

See also

• Access Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.