Constant validation rule error messages...why?

H

hawk

I am trying to run some basic append queries and continually receive
validation errors, particularly if when I'm appending based on info in
combo boxes on a form, the combo boxes are blank. At no point have I
entered ANY validation rules whatsoever into this database, so I am
lost as to why these keep appearing. Does anyone have any tips for
troubleshooting this? Is there any way to just get rid of validation
all together and have the fields accept any value?

Thanks in advance
 
J

Joan Wild

Also check the 'Allow Zero length' and 'required' properties for the fields.
Their settings will also throw up a validation rule error.
 

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

Getting 'validation rule violation' when I don't have any validation rules? 2
"validation rules violation" 2
Validation Rules Error 5
Validation Rule Error 1
validation rule error - append query 3
Validation Rule Violation with Append Query 3
blank values giving me validation error in append query 4
Append query not working due to Validation Rule Violations 14

Top