FormatConditions.Add Method (Access)
You can use the Add method to add a conditional format as a FormatCondition object to the FormatConditions collection of a combo box or text box control.
Syntax
expression .Add(Type, Operator, Expression1, Expression2)
expression A variable that represents a FormatConditions object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Type |
Required |
AcFormatConditionType |
An AcFormatConditionType constant that specifies the type of format condition to be added. |
Operator |
Optional |
AcFormatConditionOperator |
An AcFormatConditionOperator constant that specified the operator. 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 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 or a string value. |
Return Value
FormatCondition
Remarks
You can use the Delete method of the FormatConditions collection to delete an existing FormatConditions collection from a combo box or text box control.