auto increment make conflict with validation while inputing data

H

hanson

Hi, i am using access 2002. I have to input data in a field with range of 1
to 8 so that I set validation rule between 1 and 8. In datasheet view, If I
input data with values of records are 7, 8 then the value of next record
will be automaticcal filled of 9 then validation text appear. I don know how
to disable this auto-increment function.

Anyone can help please.
 
D

Dirk Goldgar

hanson said:
Hi, i am using access 2002. I have to input data in a field with
range of 1 to 8 so that I set validation rule between 1 and 8. In
datasheet view, If I input data with values of records are 7, 8 then
the value of next record will be automaticcal filled of 9 then
validation text appear. I don know how to disable this
auto-increment function.

Anyone can help please.
Click to expand...

Unfortunately, there is no way to disable this moronic misfeature in
datasheet view. The only way to avoid it is to use forms in continuous
form view, rather than datasheet view. We can only hope they'll fix it
in a future version of Access.
 
Top