Edit

FormatConditions.Add method (Access)

  • Article

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.