ValidationText Property
Applies To
Dynaset-Type Recordset object, Field object, Forward-Only-Type Recordset object, Recordset object, Snapshot-Type Recordset object, Table-Type Recordset object, TableDef object.
Description
Sets or returns a value that specifies the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting (Microsoft Jet workspaces only).
Settings and Return Values
The setting or return value is a String that specifies the text displayed if a user tries to enter an invalid value for a field. For an object not yet appended to a collection, this property is read/write. For a Recordset object, this property setting is read-only. For a TableDef object, this property setting is read-only for a linked table and read/write for a base table.
Remarks
For a Field object, use of the ValidationText property depends on the object that contains the Fields collection to which the Field object is appended, as the following table shows.
| Object appended to | Usage |
|
| Index | Not supported |
| QueryDef | Read-only |
| Recordset | Read-only |
| Relation | Not supported |
| TableDef | Read/write |
See Also
AllowZeroLength property, Required property, ValidateOnSet property, ValidationRule property, Value property.
Example
See the ValidationRule property example.
Example (Microsoft Access)
See the ValidationRule property example (Microsoft Access).