Switching off auto-fill in Access 2003 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am correcting some data in an Access table.

If I enter a 0 in a row, followed by a 1 in the next row, Access
automatically puts a 2 in the following row, if that cell is currently empty.

Is there any way of switching off this feature?
I'd be extremely grateful for any help anyone can give me on this. Thank you.
 
The only way to avoid having that happening is not to update tables
directly.

Use a form instead.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Carolyn WatD said:
I am correcting some data in an Access table.

If I enter a 0 in a row, followed by a 1 in the next row, Access
automatically puts a 2 in the following row, if that cell is currently empty.

Is there any way of switching off this feature?
I'd be extremely grateful for any help anyone can give me on this. Thank
Click to expand...
you.
 
Many thanks, Douglas!
Carolyn

Douglas J Steele said:
The only way to avoid having that happening is not to update tables
directly.

Use a form instead.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



you.
Click to expand...
 

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

How can I turn off the auto-fill numbering in Access 2
turn off auto fill in Access 5
Access 2003: populate combobox with CSV values from table column 1
Auto filled cells 1
Series fill only copying and fill series greyed out 1
auto fill a field 3
Relink of SQL Server tables in Access 2013 causes massive bloat 0
Access Control on subform / combo box requesting parameter 0

Back
Top