AllowZeroLength Property

See Also   Example   Applies To   Specifics

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.