FormatCondition Properties (Access)

Article
05/12/2016

GitHub-Mark-64px

Contribute to this content

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

Properties

Name	Description
BackColor	Gets or sets the interior color of the specified object. Read/write Long.
Enabled	You can use the Enabled property to set or return the status of the conditional format in the FormatCondition object. Read/write Boolean.
Expression1	You can use the Expression1 property to return the values of a conditional format within a FormatCondition object. Read-only String.
Expression2	You can use the Expression2 property to return the values of a conditional format within a FormatCondition object. Read-only String.
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. Read/write Long.
LongestBarLimit	Gets or sets how the longest data bar is evaluated for the specified FormatCondition. Read/write AcFormatBarLimits.
LongestBarValue	Gets or sets a numeric expression that specifies the value of the longest bar of a FormatCondition. Read/write String.
Operator	You can use the Operator property to return the operator value for the conditional format or data validation of a FormatCondition object. Read-only AcFormatConditionOperator.
ShortestBarLimit	Gets or sets how the shortest data bar is evaluated for the specified FormatCondition. Read/write AcFormatBarLimits.
ShortestBarValue	Gets or sets a numeric expression that specifies the value of the shortest bar of a FormatCondition. Read/write String.
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. Read/write Boolean.
Type	Returns the value of a FormatCondition object type. Read-only AcFormatConditionType.