This documentation is archived and is not being maintained.

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.

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

You can use the Delete method of the FormatConditions collection to delete an existing FormatConditions collection from a combo box or text box control.

Show: