Is there a way to turn off the automatic data fill in Access?

[Guest]

I sometimes use Access tables in datasheet view as tracking forms for RSVP's
to meetings, dinners, etc. The names are filled in in advance, and a field
for how many people are coming such a 1 for singles and 2 for couples is
frequently used. I have observed that if I use the down arrow to work my way
through the list, I sometimes get an automatic data fill in series. That is,
if I enter a 1, use the down arrow for the next guest and enter a 2, and hit
the down arrow again, the system begins automatically completing the series
1,2,3,4, etc. with each click of the down arrow.

This can be handy for some purposes, but can obviously cause problems if you
are working in a situation such as I describe above. If you use the down
arrow to the next name you want, skipping over records that don't need to be
filled yet, you end up with multiple guests attending when all you wanted was
to skip the record.

I have not been able to find an option to turn this off. Obviously clicking
the curser in the proper field eliminates the problem, but for people used to
using Excell tables for similar purposes, it can become a real problem.

 

[Steve Schapel]

Roy,

As far as I know, this "feature" can't be disabled. The only way around
it is to use a continuous view form for your data entry.

 

[John Vinson]

I have not been able to find an option to turn this off.

AFAIK (despite several years of loud protests to Microsoft about the
utter stupidity of this misfeature <g>) there is none. Table or Query
datasheets just insist on "helping" the user in this way.

Solution? Don't use table datasheets; use a continous Form instead. It
can be made to look just like a datasheet if you like the appearance.

John W. Vinson[MVP]