Validation Rule Error Messages

C

croy

A TextBox on my form has a Validation Rule:
=0 And <101

.... and associated Validation Text:

Must be a number between 0 and 100

The same Validation settings occur in the underlying table
field.

When using the form, and making an entry that does not fit
the rule, first my Validation Text appears, then after
clicking OK, another message appears:

"The value in the field or record violates the
validation rule for the record or field. For example..."

I don't understand why the second message is appearing, or
how to stop it. I think my text is just fine.

How can I stop the second message?
 
C

croy

What happens if you remove the rule on the text box, and just use the one in
the table?

The same behavior--my Vtext, then the canned error message.

I should mention that this is on Access 2002 (10.xxx).
 

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

Top