Tab Through Number Fields Increments Values

J

John Rager

I've opened a table that has dozens of number fields - call them field A,
field B, etc. If I enter a number in field A and hit Tab, then enter a
number in field B that is one or two greater than field A, then every
subsequent Tab puts an incremented value in the subsequent fields. For
example, if I enter 1 in field A, then Tab to field B and enter 2, then every
Tab puts incrementally higher values in the rest of the fields - 3, 4, 5,
etc. The same thing happens if I enter 1, then 3 - then I get 5, 7, 8, etc.

If I enter the same value in A & B, things work fine. If I enter something
that differs by more than 2, it works fine. It also seems to work fine if B
is less than A.

I've never seen this behavior before. I'm not using a form - just going
straight into the table. There are no macros or VB code attached to
anything, and the fields have no defaults. I did a Compact/Rebuild and also
tried a Convert for the heck of it. Any thoughts? Is there some cute little
MS thing did in Access to "help" data entry?

Any info would really be appreciated.
 
B

Brian

John Rager said:
I've opened a table that has dozens of number fields - call them field A,
field B, etc. If I enter a number in field A and hit Tab, then enter a
number in field B that is one or two greater than field A, then every
subsequent Tab puts an incremented value in the subsequent fields. For
example, if I enter 1 in field A, then Tab to field B and enter 2, then every
Tab puts incrementally higher values in the rest of the fields - 3, 4, 5,
etc. The same thing happens if I enter 1, then 3 - then I get 5, 7, 8, etc.

If I enter the same value in A & B, things work fine. If I enter something
that differs by more than 2, it works fine. It also seems to work fine if B
is less than A.

I've never seen this behavior before. I'm not using a form - just going
straight into the table. There are no macros or VB code attached to
anything, and the fields have no defaults. I did a Compact/Rebuild and also
tried a Convert for the heck of it. Any thoughts? Is there some cute little
MS thing did in Access to "help" data entry?

Any info would really be appreciated.
Click to expand...

It is indeed a cute little thing that Microsoft did to "help" you. The
dream solution would be to force Bill Gates to do the data entry for you,
and see how he likes it.

I don't know of any way to turn it off for a table in datasheet view (this
gets better and better, doesn't it?). However, you could create a form
based on the table, set "Allow AutoCorrect" to No for every control on the
form, and then open the form in datasheet view. That gets rid of the little
monster.
 
J

John Rager

Thanks Brian - I thought I was going crazy. I've never seen this behavior
before but I don't do a lot of entry directly into tables. Thanks again.
 
Top