Article ID: 271607 - View products that this article applies to.
This article was previously published under Q271607
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
Novice: Requires knowledge of the user interface on single-user computers.
When you use the TAB key to move through empty fields or use the DOWN ARROW key to move down to new records in an Access 2000 table, Microsoft Access may automatically populate the next field or record with a value.
Microsoft Access 2000 includes a new feature that is named AutoFill. This feature is built into Access, and it is always enabled. You cannot disable it.
AutoFill applies only to Access tables that have fields with certain data types and works only if you enter certain multiples of numbers. The following two lists indicate which field types are affected by AutoFill, based on the type of Access table (MDB or ADP tables) that you are using.
Access MDB Fields:
Number (if the field's DefaultValue property is blank)
Access ADP Fields:
binaryTo see how AutoFill functions, follow these steps:
If any of the supported field types are contiguous, AutoFill applies. In other words, within an Access table, if Fld1 were Text, and Fld2 were Number (without a default value), and Fld3 were Text, AutoFill would still apply when you press the TAB key to move from field to field. However, if the field types that support AutoFill are separated by other field types that do not support AutoFill, AutoFill is not applied. If the Text fields were separated by Currency fields, AutoFill would not be applied when you press the TAB key to move from one field to the next. In this case, however, AutoFill still applies if you press the DOWN ARROW key to move down to new records.