Validation rules stops the user from going forward.

[jinalpatel]

I have two tables Mainfirm and Subfirm. I have everything ready. Now I am entering validation rules like as below in my form fields to protect the tables from bad data. But when I try to enter something wrong, it gives me error and it sticks to that error message,. It does not let me go forward.
Is Null OR Not Like "*[!a-z]*"
Is Null OR Not Like "*[!0-9]*"
Is Null OR Not Like "*[!((a-z) or (0-9))]*"
Also, I tried to enter validation rules to the table itself instead of each and every form fields. Still the same.

Please help...It is driving me nuts!!

[missinglinq]

I think we need to get a couple of things straight before we begin here.

"it gives me error and it sticks to that error message,. It does not let me go forward"

What exactly do you mean by this? Does it not let you attempt to correct your incorrect entry in the textbox?

"Is Null OR Not Like "*[!a-z]*""

Exactly what type of data do you expect this Validation rule to allow?

Linq ;0)>

[jinalpatel]

I think we need to get a couple of things straight before we begin here.

"it gives me error and it sticks to that error message,. It does not let me go forward"

What exactly do you mean by this? Does it not let you attempt to correct your incorrect entry in the textbox?

"Is Null OR Not Like "*[!a-z]*""

Exactly what type of data do you expect this Validation rule to allow?

Linq ;0)>

Ya
I have several textboxes for data entry. Like License number, Firmname,addres s,city etc.I am using "Is Null OR Not Like "*[!a-z]*"" validationrule for my FirmName. Now supoose I try to edit the existing data and by mistake I type any number like 4 instead of any character like A to Z.
I get an error message(which is my validationtext) "Please enter valid Firmname." Now if I click "OK" on this message and retype in FirmName textbox. It again gives me the same error message as I just listed. The same is keep going untill I quit the application itself.

I tried to put the validation rules and validationtext on both
1)Form
2) Tables itself.
But none of them seemed to be working

Please help

[missinglinq]

I don't know what to tell you. The validation rule is correct for what you're trying to do. I used it without problem, both n the table as well as in the form, and jsut for kicks I tried it in both! When placing it in both and entering data thru the form, the form's Validation is the one that prevails; I know this because I varied the Validation text between the table and form. HAve you tested the other fields that have validations in place? Do all these fields fail or have you just tested the FirnName field?

Linq ;0)>

[jinalpatel]

I don't know what to tell you. The validation rule is correct for what you're trying to do. I used it without problem, both n the table as well as in the form, and jsut for kicks I tried it in both! When placing it in both and entering data thru the form, the form's Validation is the one that prevails; I know this because I varied the Validation text between the table and form. HAve you tested the other fields that have validations in place? Do all these fields fail or have you just tested the FirnName field?

Linq ;0)>

Thankf for your help.
I was doing one silly mistake of entering space. Now I changed my validation rules to "Like "*[a-z]*" Or Like "?"" and it is working perfectly. I worked on this problem almost 3-4 days..and see I was doing just one mistake..
Thanks for your help
Thanks much.

[missinglinq]

Don't mean to upset your apple cart, but you do realize by adding the "?" that you can actually enter anything now, letters, special characters and numbers! You essentially have no validation at all.

Every attempt I make to include spaces, including using the ASCII designation, results in the same thing. But to be perfectly frank, I dodn't really understand the need to exclude numbers from the FirmName field; there are many companies, today, whose names do include numbers.

Linq ;0)>

[jinalpatel]

Don't mean to upset your apple cart, but you do realize by adding the "?" that you can actually enter anything now, letters, special characters and numbers! You essentially have no validation at all.

Every attempt I make to include spaces, including using the ASCII designation, results in the same thing. But to be perfectly frank, I dodn't really understand the need to exclude numbers from the FirmName field; there are many companies, today, whose names do include numbers.

Linq ;0)>

Firmname is just an example from many other fields. I have Person's name,county,cit y etc.
Can you tell me how can I be specific to only space and not any other characters regarding first paragraph of ur reply. It will be too helpful if you can suggest me the validationrule that only accepts alphabets from a to z and white space.

Thanks for pointing out.

[Jane Doe]

I am having the same issue as jinalpatel.
When I enter in something that does not follow the Validation rule I get the error message which is correct and what I would like however when I try to correct the error the msg will not allow me to do so.
any suggestions?