Validation rule problems

[Gina Maylone]

Happy Friday all!

In order for me to get the sequential numbering to work appropriately, I need to save a record early on, but this is giving me fits with the validation rules. "Is Null Or Between 0.001 And 99.99", I have "is null or" on every validated field, but am getting validation errors. any ideas on how I can get around this? Besides removing all validation? I thank you in advance!

[aytee111]

Check the field's datatype, if it is a number then the default is 0, not null. Haven't tested it but couldn't you use "< 100"? Also check that required isn't set to yes.

[Gina Maylone]

Check the field's datatype, if it is a number then the default is 0, not null. Haven't tested it but couldn't you use "< 100"? Also check that required isn't set to yes.

That was it! Zero not null!! DUH! Thank you so much!!

[June7]

0 is default if you set the field or textbox to use. Since I developed a db that recorded laboratory test results and 0 could be a valid result of testing, I did not want it saved by default when record was created because a particular segment for a test might not be completed in which case there was no data, not even 0. So I always removed the 0 default setting when formatting tables. Therefore I needed validation to allow for null. Validation rule seemed to work best with Or Is Null as the last condition.