Entry into table anticipates that next entry

M

Maria

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?
 
J

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
 
J

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?
Click to expand...

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]
 
Top