Auto incrementing fields

[J. Shrimps Jr.]

Have a table with several fields.
Three of the fields are numeric int.
Let's say Field1, Field2, Field3.
Sometimes when I enter values in Field1,
and tab over to Field2, Field2
is populated with Field1's value plus 1.
Same with Field3.
Have created a datasheet form for this table
didn't make any difference (at times) after
entering a number in Field1,
Field2 is Field1, plus 1.
This only happens sometimes.
What do I need to change either in the design
of the table or Access Options to change this?

 

[Joan Wild]

This annoying feature is called 'autofill'. There is no way to turn it off
in the options.

One workaround is to set a default value for your fields (which you may not
want either).

You should create a form for data entry - it won't occur there.

 

[J. Shrimps Jr.]

I created a datasheet autoform,
with the same result.

 

[Roger Carlson]

Ain't it *wonderful* how Microsoft keeps adding "features" that most
developers find useless and even harmful? Autofill, AutoCorrect,
Subdatasheets, Lookup fields...

Don't they ever run ideas past their own MVPs?

 

[Joan Wild]

I cannot reproduce this when using a datasheet style form.

Try a continuous form.

 

[J. Shrimps Jr.]

I have inserted text fields with a default
value of "blank" between each numeric field.
This has stopped the autofill behaviour.
NOTE: Leaving the text fields empty
results in the text field being populated
with the value of the previous field, plus 1!!
You have to have a text string in the text field.

 

[Matt Flinner]

I am experiencing the same. I have found no way to turn it off either but i wanted to ask if you have confirmation from microsoft themselves that it cannot be turned off. I was hoping I could flip a proverbial switch in the registry somewhere or through an Access property that can only be set through VBA code.

 

[Joan Wild]

I am experiencing the same. I have found no way to turn it off
either but i wanted to ask if you have confirmation from microsoft
themselves that it cannot be turned off. I was hoping I could flip a
proverbial switch in the registry somewhere or through an Access
property that can only be set through VBA code.

Nope, can't be turned off. Your users shouldn't be entering directly into
tables anyway. Create suitable forms to enter data.