Access - Autofill off

[Karen Howie]

Hello,

We have an access database which staff use to enter information. One of the
fields is a text field but generally contains a number. The staff members
have to go in and edit it from time to time but what we've noticed is that if
they type say '1' into the field and then press the downward arrow key to go
and find the next field which needs filling in, if the field directly after
is blank, it is automatically filled in with '2'. This is causing real
problems in this particular situation as the staff members don't always
notice this autofill and it makes the data incorrect.

Does that make sense?
Please let mw know if there is an answer to this somewhere and I've just
been searching for the wrong thing.

Thanks in advance!

Kind regards

Karen Howie

 

[Rick Brandt]

Hello,

We have an access database which staff use to enter information. One
of the fields is a text field but generally contains a number. The
staff members have to go in and edit it from time to time but what
we've noticed is that if they type say '1' into the field and then
press the downward arrow key to go and find the next field which
needs filling in, if the field directly after is blank, it is
automatically filled in with '2'. This is causing real problems in
this particular situation as the staff members don't always notice
this autofill and it makes the data incorrect.

Does that make sense?
Please let mw know if there is an answer to this somewhere and I've
just been searching for the wrong thing.

It's a stupid "feature" and it cannot be turned off. It should be of little
consequence though as users should NEVER enter data directly into tables anyway.
Give them a form (even a datasheet form) and the problem is gone.

 

[Karen Howie]

Thanks Rick - good advice.

Karen

It's a stupid "feature" and it cannot be turned off. It should be of little
consequence though as users should NEVER enter data directly into tables anyway.
Give them a form (even a datasheet form) and the problem is gone.