Modify Method [Access 2003 VBA Language Reference]

  • Article

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 Required. An expression that returns one of the objects in the Applies To list.

AcFormatConditionType

AcFormatConditionType can be one of these AcFormatConditionType constants.
acExpression
acFieldHasFocus
acFieldValue

AcFormatConditionOperator

AcFormatConditionOperator can be one of these AcFormatConditionOperator constants.
acBetweendefault
acEqual
acGreaterThan
acGreaterThanOrEqual
acLessThan
acLessThanOrEqual
acNotBetween
acNotEqual

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

Applies to | FormatCondition Object