This article describes the default values for the AllowZeroLength field properties and for the Indexed field properties. When you create a new table in Microsoft Office Access, the default values for the AllowZeroLength field properties and for the Indexed field properties may differ from the default values in earlier versions of Access.

Back to the top

You can you create a table with a field that contains any one of the following data types in an Access database:

•	Text
•	Memo
•	Hyperlink

Note The default values for the AllowZeroLength field properties and for the Indexed field properties may differ from the default values of the field properties in Access 2000.

The following table describes the default values of the field properties that correspond to the specified fields in the different versions of Access:

		AllowZeroLength	Indexed
Microsoft Office Access 2003 Microsoft Access 2002
	Text	Yes	No
	Memo	Yes	No
	Hyperlink	Yes	No
Microsoft Access 2000
	Text	No	No
	Memo	No	<Not Specified>
	Hyperlink	No	<Not Specified>

You must make sure that when you create a table in an Access database that you explicitly set the values of the AllowZeroLength field properties and of the Indexed field properties so that these field properties correspond to the Text data type, to the Memo data type, or to the Hyperlink data type.

Back to the top

For more information about available data types and field properties, click the following article number to view the article in the Microsoft Knowledge Base: For more information about the AllowZeroLength field property in Access 2000, click the following article numbers to view the articles in the Microsoft Knowledge Base:

Back to the top