Stop Access 2003 from automatically filling in data.

G

Guest

I'm trying to find out why Access 2003 will auto fill my data entries. I've
noticed that when I put a number in a field that the next record will
automatically insert the next number in that field. For example, in my Order
column, in datasheet view, I enter a 1, the next record in the the Order
column will automatically fill with a 2 and so on. Or the pattern will
repeat - if I enter a 1 in the Order field, then a 3 in the next Order field,
the next Order field will fill with a 5. What is going on? and how do I stop
this?
 
D

Duane Hookom

You can't stop this "feature" when using a table datasheet view for entering
records. Use a form for entering and editing records.
 

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

Similar Threads

Stop Access automatically filling values into fields 1
Autofill in Query 5
Number Fields in Access 2007 Database 1
How To Auto-Increment A Field In MS Access 2007? 4
When entering data, Access automatically enters the next sequenti. 3
Create sequence number for table 6
Numbering in Access 1
How to auto increment integer entries without autonumber in 2007 3

Top