FormatCondition Members (Access)

GitHub-Mark-64px

Contribute to this content

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

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

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.

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.

Show: