Help and Support

Article ID: 837147 - Last Review: June 4, 2007 - Revision: 2.0

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

This article applies only to a Microsoft Access database (.mdb).

Novice: Requires knowledge of the user interface on single-user computers.
Expand all | Collapse all

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, 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 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:
Collapse this tableExpand this table
AllowZeroLengthIndexed

Microsoft Office Access 2003
Microsoft Access 2002
TextYesNo
MemoYesNo
HyperlinkYesNo
Microsoft Access 2000
TextNoNo
MemoNo<Not Specified>
HyperlinkNo<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.

REFERENCES

For more information about available data types and field properties, click the following article number to view the article in the Microsoft Knowledge Base:
824263  (http://support.microsoft.com/kb/824263/ ) Information about data types and field properties that can be used in an Access database
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:
209098  (http://support.microsoft.com/kb/209098/ ) Using the AllowZeroLength and Required properties
210278  (http://support.microsoft.com/kb/210278/ ) How to set AllowZeroLength Property to Yes in all tables

APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbtable kbfield kbproperties kbdatabase kbinfo KB837147

Article Translations

 

Related Support Centers