FormatCondition.Modify method (Access)
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.
Syntax
expression.Modify (Type, Operator, Expression1, Expression2)
expression A variable that represents a FormatCondition object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Type | Required | AcFormatConditionType | An AcFormatConditionType constant that specifies the type of condition to be modified. |
| Operator | Optional | AcFormatConditionOperator | An AcFormatConditionOperator constant that specifies the type of operator to be used. 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.