Microsoft Access XP -- turn off autofill

[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.

 

[John Vinson]

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.

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.

 

[Felix S.]

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?

 

[John Vinson]

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?

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.

 

[Joan Wild]

If the field you are trying it on has a default value, then it won't
autofill.