FormatCondition Members (Access)

Article
10/12/2015

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

Methods

Name	Description
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

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: When displaying or printing controls on forms and reports. When using the Print method on a report. Read/write Boolean.
FontItalic	You can use the FontItalic property to specify whether text is italic in the following situations: When displaying or printing controls on forms and reports. When using the Print method on a report. Read/write Boolean.
FontUnderline	You can use the FontUnderline property to specify whether text is underlined in the following situations: When displaying or printing controls on forms and reports. When using the Print method on a report. Read/write Boolean.
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.