Microsoft Access XP -- turn off autofill

  • Thread starter Thread starter Felix S.
  • Start date Start date
F

Felix S.

How do I turn off list autofill in Access XP? In a table
or query if I enter "3" in one record then "4" in the
same field of the next record, Access will automatically
put a "5" in the next record.
 
How do I turn off list autofill in Access XP? In a table
or query if I enter "3" in one record then "4" in the
same field of the next record, Access will automatically
put a "5" in the next record.
Click to expand...

This is a very annoying misfeature introduced with A2000. There is no
way to turn it off in table or query datasheets.

Solution? Don't use datasheets; create a continuous Form instead.
 
Thanks. I thought as much. Talk about a problem in search
of a solution. I wouldn't even know how to use
the "feature" to my advantage. Do you know if it was
continued in 2003?
 
It does not seem to be doing it in XP.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math
 
Thanks. I thought as much. Talk about a problem in search
of a solution. I wouldn't even know how to use
the "feature" to my advantage. Do you know if it was
continued in 2003?
Click to expand...

My guess is that it was code written for a spreadsheet (it's
potentially a quite useful feature in Excel) that some bright person
(who knew nothing about relational database design, unfortunately)
thought would be useful in Access too.

I'm not sure where Joseph was testing it, but my AccessXP database
still does it if I edit a numeric field in a table datasheet.
 
I made a table and tried to get it to function as such and it would not
auto fill. If I have a unique version, I guess I am happy about it.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math
 
Yea, that's it. that may also be the answer to the original question
"How do I turn off list autofill in Access XP?"
 
Back
Top