FormatCondition.Operator (Access)

You can use the Operator property to return the operator value for the conditional format or data validation of a FormatCondition object. Possible return values are acBetween - The value must be between the values specified by the Expression1 and Expression2 arguments, acEqual - The value must equal to the value specified by the Expression1 argument, acGreaterThan - The value must be greater than the value specified by the Expression1 argument, acGreaterThanOrEqual - The value must be greater than or equal to the value specified by the Expression1 argument, acLessThan - The value must be less than the value specified by the Expression1 argument, acLessThanOrEqual - The value must be less than or equal to the value specified by the Expression1 argument, acNotBetween - The value must not be between the values specified by the Expression1 and Expression2 arguments, acNotEqual - The value must not be equal to the value specified by the Expression1 argument.

The Operator property's intrinsic constants are used in conjunction with the Expression1 and Expression2 properties and the Add method of the FormatConditions object for conditional formatting and data validation.

CreateForm.Controls(1).FormatConditions(1).Operator