Class FormatCondition (Access VBA)

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

Methods

Delete - Deletes the specified object.

Modify - You can use the Modify method to change the format conditions of a FormatCondition object in the FormatConditions collection of a combo box or text box control.

Properties

BackColor gets or sets the interior color of the specified object.

Enabled you can use the Enabled property to set or return the status of the conditional format in the FormatCondition object.

Expression1 you can use the Expression1 property to return the values of a conditional format within a FormatCondition object.

Expression2 you can use the Expression2 property to return the values of a conditional format within a FormatCondition object.

FontBold you can use the FontBold property to specify whether a font appears in a bold style in the following situations:.

FontItalic you can use the FontItalic property to specify whether text is italic in the following situations:.

FontUnderline you can use the FontUnderline property to specify whether text is underlined in the following situations:.

ForeColor you can use the ForeColor property to specify the color for text in a control.

LongestBarLimit gets or sets how the longest data bar is evaluated for the specified FormatCondition.

LongestBarValue gets or sets a numeric expression that specifies the value of the longest bar of a FormatCondition.

Operator you can use the Operator property to return the operator value for the conditional format or data validation of a FormatCondition object.

ShortestBarLimit gets or sets how the shortest data bar is evaluated for the specified FormatCondition.

ShortestBarValue gets or sets a numeric expression that specifies the value of the shortest bar of a FormatCondition.

ShowBarOnly gets or sets whether the data bar or the data bar and its value are displayed. Set to True to display only the data bar.

Type returns the value of a FormatCondition object type.