Entry into table anticipates that next entry

[Guest]

For example, I have a group of fields that accept blank, 0,1,2 as valid
values. When I enter 1 and the 2 in consecutive fields, the next field is
automatically set to 3, which isn't even a valid option. Is there a way to
disable this automatic feature?

 

[Jeff Boyce]

Maria

No (and Yes).

If you do data entry directly in the table, Access "helps" in this way.

But Access tables are where you store data. Use Forms to add/edit data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

For example, I have a group of fields that accept blank, 0,1,2 as valid
values. When I enter 1 and the 2 in consecutive fields, the next field is
automatically set to 3, which isn't even a valid option. Is there a way to
disable this automatic feature?

Yes. Don't use tables for data entry.

This is a misfeature introduced with A2000, as I recall; it might make sense
in Excel but certainly doesn't in Access.

You can use a continuous Form for your data entry; it doesn't suffer this
lapse.

John W. Vinson [MVP]