Default values for the AllowZeroLength field properties and for the Indexed field properties that you create in Access 2002 or in Access 2003 may differ from earlier versions of Access (837147)

INTRODUCTION

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 2003 or in Access 2002, 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.

MORE INFORMATION

You can you create a table with a field that contains any one of the following data types in an Access 2003 database or in an Access 2002 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 2003 database or in an Access 2002 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.

REFERENCES

For additional information about available data types and field properties, click the following article number to view the article in the Microsoft Knowledge Base:

824263 Information about data types and about field properties that can be used in an Access 2003 database

For additional information about the AllowZeroLength field property in Access 2000, click the following article numbers to view the articles in the Microsoft Knowledge Base:

209098 ACC2000: Using the AllowZeroLength and Required properties

210278 ACC2000: How to set AllowZeroLength Property to Yes in all tables