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).