Hi
I'm confused about the Access validation rule for text only fields. All the support states to use:
Not Like "*[!a-z]*"
This is difficult for the students I teach to understand.
I tried to teach them:
Like "*[a-z]*"
instead, which should be logically equivalent and easier to grasp. However, this does not work for a mixture of letters and numbers i.e. Jo6n. The first version of the rule does catch this and correctly reports an error. But why is this so?
Thanks
Bryan