Table of contents
TOC
Collapse the table of content
Expand the table of content

FormatCondition.Modify Method (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

You can use the Modify method to change the format conditions of a FormatCondition object in the FormatConditions collection of a combo box or text box control.

Syntax

expression. Modify( ** Type, ** Operator, ** Expression1, ** Expression2 )

expression A variable that represents a FormatCondition object.

Parameters

NameRequired/OptionalData TypeDescription
TypeRequiredAcFormatConditionTypeA AcFormatConditionType constant that specifies the type of condition to be modified.
OperatorOptionalAcFormatConditionOperatorA AcFormatConditionOperator constant that specifies the type of operator to be used.

Note 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 value 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 value or a string value.|

Return Value

Nothing

See also

Concepts

FormatCondition Object

© 2017 Microsoft