Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

FormatCondition Members (Access)

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:

  • 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.

Show:
© 2015 Microsoft