Validation arguments

[Carol Shu]

I'm trying to set up a field that will allow you to type in anything but no
letters "I", "O" and "Q" how to do this with my validation rule? Thanx!

 

[Allen Browne]

I'm trying to set up a field that will allow you to type in anything but
no
letters "I", "O" and "Q" how to do this with my validation rule? Thanx!

Try:
Is Null OR Not (Like "*I*" OR Like "*O*" OR Like "*Q*)

More information on validation rules:
http://allenbrowne.com/ValidationRule.html

 

[Carol Shu]

it says
"the expression you entered has an invalid string"

 

[Allen Browne]

Sorry: missed a closing quote:
Is Null OR Not (Like "*I*" OR Like "*O*" OR Like "*Q*")