How to Disable???

G

Guest

How do I disable the AutoFill feature when working within a table in Access
2003. As I enter a quantity and move down to the next record, Access wants to
fill in a quantity automatically. I type 1, move to next record, type a 2,
move to the next record and a 3 is filled in. I want to stop the AutoFill
feature. How??
 
F

fredg

How do I disable the AutoFill feature when working within a table in Access
2003. As I enter a quantity and move down to the next record, Access wants to
fill in a quantity automatically. I type 1, move to next record, type a 2,
move to the next record and a 3 is filled in. I want to stop the AutoFill
feature. How??

As far as I can remember, you cannot change this 'feature'.
But the question is ... why are you entering data directly into a
table.? Tables are for storing data.
Use a Form, bound to this table, to enter data into. That's what they
are for. If you wish to have a table like view as you enter data, set
the form to Datasheet View. It looks like a table, but you will not
have that Autofill feature, and you have the advantage of having the
form events to verify that the data is entered or formatted correctly,
etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top