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.
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 |
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. .gif "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