Export (0) Print
Expand All

FormatCondition.Modify Method (Access)

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.

expression .Modify(Type, Operator, Expression1, Expression2)

expression A variable that represents a FormatCondition object.

Parameters

Name

Required/Optional

Data Type

Description

Type

Required

AcFormatConditionType

A AcFormatConditionType constant that specifies the type of condition to be modified.

Operator

Optional

AcFormatConditionOperator

A AcFormatConditionOperator constant that specifies the type of operator to be used.

Note Note

If the type argument is acExpression, the operator argument is ignored. If you leave this argument blank, the default constant (acBetween) is assumed.

Expression1

Optional

Variant

A value or expression associated with the first part of the conditional format. Can be a constant value or a string value.

Expression2

Optional

Variant

A value or expression associated with the second part of the conditional format when the operator argument is acBetween or acNotBetween (otherwise, this argument is ignored). Can be a constant value or a string value.

Return Value

Nothing

Show:
© 2014 Microsoft