Switching off autocomplete function? Access 2000

[Guest]

Whenever I enter numeric data into a field of an Access 2000 table (not via a
form) and advance to the next record, it will attempt to autocomplete - so if
one record has a value 4 in that field, the next 5, and I move to the next
record, it will insert 6. How do I stop this? I can't see anything in Tools /
Options to help.

 

[Scott McDaniel]

Whenever I enter numeric data into a field of an Access 2000 table (not via a
form) and advance to the next record, it will attempt to autocomplete - so if
one record has a value 4 in that field, the next 5, and I move to the next
record, it will insert 6. How do I stop this? I can't see anything in Tools /
Options to help.

FWIW, I've never seen an option to turn this off either. Of coure, the obvious answer is "Don't let users enter data
directly in a table" (which is very good advice, BTW), but the behavior also occurs on forms viewed as Datasheets. It
doesn't occur in forms viewed as Continuous forms (and you can build them to look almost identical to a table in
Datasheet view).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com