How do I turn off the automatic entering of numbers in records?

G

Guest

When I am typing numbers into a table, Access automatically completes
"series" for me. For instance, if adjacent cells (either horizontal or
vertical) have consecutive values, once I move to the next cell with the tab
or arrow keys, the next number in the supposed series is automatically
entered. If I type a 1, and a 2 in the next cell, and hit tab, Access adds a
3 automatically. If I have 1 and 3, Access adds a 5. I cannot figure out
how to turn this off for the life of me, as I don't know what this feature is
called. It's extremely likely to lead to errors in my databases!

Thanks for any help.
 
C

Claton Hendricks

Hi

"Turn Off Auto Correct" from Tools -- AutoCorrect.

Claton Hendricks

Microsoft Access Engineer.
 
D

Douglas J. Steele

None of us can understand why they introduced that "feature" into Access,
especially with no way of turning it off.

The solution is not to add data directly to the table. Use a form instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering numbers in column, how to turn off auto sequencing? 12
Turn off increment 1
How can I turn off the auto-fill numbering in Access 2
Turn Off AutFill in Datasheet 4
Is there a way to turn off the automatic data fill in Access? 2
turn off automatic features 3
How do I avoid autofilling of numbers as you tab across fields? 1
Don't want automatic sequential numbering in Access 2003 4

Top