Sets or returns a value that indicates whether a zero-length string ("") is a valid setting for the Value property of the Field object with a Text or Memo data type (Microsoft Jet workspaces only).
Settings and Return Values
The setting or return value is a Boolean data type that indicates if a value is valid. The value is True if the Field object accepts a zero-length string as its Value property; the default value is False.
Remarks
For an object not yet appended to the Fields collection, this property is read/write.
Once appended to a Fields collection, the availability of the AllowZeroLength property depends on the object that contains the Fields collection, as shown in the following table.
| If the Fields collection belongs to an | Then AllowZeroLength is |
| Index object | Not supported |
| QueryDef object | Read-only |
| Recordset object | Read-only |
| Relation object | Not supported |
| TableDef object | Read/write |
You can use this property along with the Required, ValidateOnSet, or ValidationRule property to validate a value in a field.