AllowZeroLength Property

See Also   Applies To

Sets or returns a value that indicates whether a zero-length string ("") is a valid setting for the Value property of the CdbField object with a Text or Memo data type.

Syntax

VOIDSetAllowZeroLength(BOOL bFlag);

BOOLGetAllowZeroLength(VOID);

Parameters

Type Example Description
BOOL bFlag TRUE if the CdbField object accepts a zero-length string as its Value property.

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 a Then AllowZeroLength is
CdbIndex object Not supported
CdbQueryDef object Read-only
CdbRecordset object Read-only
CdbRelation object Not supported
CdbTableDef object Read/write

You can use this property along with the Required, ValidateOnSet, or ValidationRule property to validate a value in a field.