Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation Rule/Text not working

Status
Not open for further replies.

sohunter

Technical User
Dec 3, 2001
106
0
0
US
I'm trying to use field/control properties (instead of code) to enforce a simple validation rule. But it doesn't work. I've tried setting the property for the field (and/or control) at both table level, form level, and table and form level. It catches the validation problem, but doesn't let you tab out of the field. No validation message, which is what it's supposed to do.

I'm requiring a comma before and after entry, so my validation rule is

Like ",*,"

and my validation text is:

Please make sure that each clone has comma before and after it.

-----

The rule is enforced, so I don't think that's the problem, it just isn't responding correctly. Any ideas what's going on?
 
No.
Just tested it here and it works ok for me setting the rule at field level in the table design.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top