auto increment make conflict with validation while inputing data

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

Guest

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.
 
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.
 

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

reorder auto increment 3
How to specify a validation rule with multiple criteria 3
Stop Access auto-suggesting increments during data entry (datashee 2
Auto-Increment Issue (couldn't find this one) 4
Data Entry Form and Auto Number ID 2
How to auto increment integer entries without autonumber in 2007 3
validation rule (for a record in a table) with dlookup 7
Custom validation rule - must be 15 increment of time 1

Back
Top