Microsoft Access Field Properties – Allow Zero Length

Allow Zero Length

Field properties are where you fine tune the table.  The data type provides general information about the type of data that a field is going to contain and in the properties is where you define it more exactly.

This property only applies to text fields.  When this property is set to Yes, you can enter zero-length strings in a field.  A zero-length string contains no characters.

You use it to indicate that you know no value exists for a field, so that when you query the data you can separate between not knowing if the data exists and knowing that there is no data.

You enter a zero-length string by typing two double quotation marks with no space between them (“”).