Trouble with default values in a table

J

JLangley3

I have a table where all of the values are null, 0, or 1. If the record
happens to fall column 1 = 0, column 2 = 1 then access tries to complete the
series by making column 3 = 2 even though the default value is set to null.
Is there any way to turn this "auto complete" off? I'm using Access 2002.
Thanks in advance for any suggestions.
 
A

Arvin Meyer [MVP]

If you work in the tables (you shouldn't) or use a datasheet view,
AutoComplete remains on. The solution is to use a continuous form, which can
be made to look like a datasheet, if that's what is desired.
 
Top