Table of contents
TOC
Collapse the table of content
Expand the table of content

FormatCondition Object (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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

Remarks

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.

Methods

Name
Delete
Modify

Properties

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

See also

Other resources

Access Object Model Reference

© 2017 Microsoft