Microsoft KB Archive/113493

= ACC: Using the AllowZeroLength and Required Properties =

Article ID: 113493

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q113493



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
The AllowZeroLength property determines whether a zero-length string ("") is a valid entry. The Required property determines whether a Null value is a valid value. Although these two properties work together, the AllowZeroLength property overrides the Required property.



MORE INFORMATION
The AllowZeroLength property determines whether a zero-length string ("") is a valid entry, and is available only for Text and Memo fields. Microsoft Access versions 2.0 and above support both Null and zero-length strings in Text and Memo fields. (Microsoft Access version 1.x does not allow zero-length strings in a Text or Memo field. In Microsoft Access 1.x, if a user deletes data in an existing field, or does not enter data in a field, the value saved for the field is a Null. To be compatible with Microsoft Access 1.x applications, the default for the AllowZeroLength property is No.)

The Required property determines whether a Null value is a valid value. Although the AllowZeroLength and Required properties work together, the AllowZeroLength property overrides the Required property. For example, if AllowZeroLength is set to Yes, a zero-length string is a valid value for the field regardless of the Required property setting. To enter a zero- length string in a field, type two double quotation marks ("").

You can use the AllowZeroLength and Required property settings to differentiate between information that does not exist, and information that may exist. For example, you might have employees in your database who do not have a home phone. If AllowZeroLength is set to Yes, Required is set to No, and DefaultValue is left blank for the HomePhone field, you can enter two double quotation marks to indicate that an employee does not have a home phone. If you leave the field blank (do not type text or delete any existing text), it indicates that the employee may have a home phone, but you do not know what it is.

The following table shows the results you can expect when you combine the AllowZeroLength and Required property settings:

 AllowZeroLength   Required      User's action        Value displayed -     No              No         Presses ENTER             Presses SPACEBAR         Types ""             (not allowed)

Yes            No         Presses ENTER             Presses SPACEBAR         Types ""                  ""

No             Yes        Presses ENTER         (not allowed) Presses SPACEBAR     (not allowed) Types ""             (not allowed)

Yes            Yes        Presses ENTER         (not allowed) Presses SPACEBAR          "" Types ""                  ""

