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

[Matt Flinner]

I created a table in either a Sql Server db or an MDB file with 3 or more integer type fields together. For example: RecordID int (key), f1 int, f2 int, f3 int, f4 int

Then I tested entering data into this table through the table's datasheet view.

if you enter 1 in f1, 2 in f2 and tab to f3, f3 will automatically be given the value of 3. I don't want this behaviour and I need to know how to turn it off.

This doesn't occur if you set a the default value of the fields to a numeric value. But i need the default to be null because in our case zero represents something very different from null.

Has anyone experienced this? Can replicate it?

Thanks

 

[John Vinson]

On Tue, 15 Jun 2004 12:02:01 -0700, Matt Flinner <Matt

if you enter 1 in f1, 2 in f2 and tab to f3, f3 will automatically be given the value of 3. I don't want this behaviour and I need to know how to turn it off.

This obnoxious misfeature was introduced with Access2000 and (despite
vehement protests) has not been removed. There is no way to turn it
off.

The getaround is to avoid using table datasheets for data entry. If
you create a continuous Form based on this table you won't suffer the
problem.