FormatConditions.Add method (Access)
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 specifies 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
Use the Delete method of the FormatConditions collection to delete an existing FormatConditions collection from a combo box or text box control.
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.