number "prediction" - turning it off

G

Guest

In Access, when you (for example) type a 1 into one column, then a 2 in the
next column, the program automatically inserts a 3 into the next. This same
thing happens for sequences such as (2,4,6 or 1,3,5 or 11,13,15 etc).
However, if I have 2 number columns, and then a lookup drop-down box, when it
automatically "predicts" the third number in the sequence, it then complains
that I haven't selected a valid option from the list. It's a small issue, but
can be annoying when I'm trying to go quickly through a lot of data. Does
anyone know how to turn it off?
 
S

Steve Schapel

Markd,

However, I believe this "feature" only applies to datasheets. If you
use a continuous view form instead for your data entry (you can format
it to look pretty much like a datasheet if you like :) then you will
not get this troublesome behaviour.
 

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

Formula for Football (Soccer) Prediction League 1
Entering numbers in column, how to turn off auto sequencing? 12
lookup and return column number 2
autonumbering question 1
Turning a 3 column flat file into a "3D" Table 2
Macro to create different groups 1
Windows 7 64bit Auto shutdown problem 1
Power plan wont shut off fans after sleep settings 8

Top