Switching off autocomplete function? Access 2000

  • Thread starter Chris in Cumbria
  • Start date
C

Chris in Cumbria

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.
 
S

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.
Click to expand...

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
 
Top