>

ValidateOnSet Property

Applies To

Field Object.

Description

Sets or returns a value that specifies whether or not the value of a Field object is immediately validated when the object's Value property is set. Only Field objects in Recordset objects support the ValidateOnSet property as read/write.

Settings and Return Values

The setting or return value is a Boolean expression that indicates whether a value is validated, as described in Settings. The data type is Boolean. The possible settings or return values are:

Setting/Value

Description

True

Validate when the property is set.

False

Validate when the record is updated.


Remarks

When the ValidateOnSet property is set to True (-1), the validation rule specified by the ValidationRule property setting of the Field object is checked when you set the object's Value property.

When the ValidateOnSet property is set to False (0), you can set the Value property of each field independently and perform validation using the final value settings when the record is updated.

See Also

AllowZeroLength Property, QueryDef Object, Required Property, ValidationRule Property, ValidationText Property, Value Property.