Turn off autocomplete??

[BaudKarma]

I'm working on a database which has me typing some survey results into a database. My problem occurs when a few of the values coincidentally appear to be in a sequence. After the second or third number is typed in, Access decides I'm making a sequential list and helpfully fills in the next field. Of course that's NOT what I'm doing, so that number is wrong and I have to doubletake and backspace and fill in the proper number.

Is there any way to turn this off? I poked around in options, but didn't see anything that looked helpful.



I try not to let my ignorance prevent me from offering a strong opinion.

 

[dhookom]

Don't waste your time looking for a switch to turn this off. There isn't one.

You should create a form for doing your data entry rather than entering your data directly into a table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]