Access is autofilling field values when i don't want it to

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

Guest

I created a table in either Sql Server or an MDB file with a recordId (key) and a set of integer type fields. For example: recordId int (key), f1 int, f2 int, f3 int, f4 int

Then I tested data entry into this table by opening the table directly (through an Access project file for Sql Server).

if I enter 1 in f1, 2 in f2 then tab to f3, f3 now has a value of 3, tabbing to f4 also results in a value of 4 in that field. I need to turn off this behavior but i can't find anything documenting its existence.

If you set the default value of the fields to a numeric value then the behavior doesn't occur. However I need the default to be a null

Has anyone experienced this?

Thanks
 
It's called autofill, and as I answered in the other thread, there is no way
to turn it off. Create forms for data entry - users shouldn't even have
access to the tables. This behaviour will not occur in a form.
 
Back
Top