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