Hi,
I'm really struggling to try and find a solution to a problem.
I need to find a validation rule that only accepts:
letters, spaces and hyphens (-) in the field.
I have tried for at least 14 hours today and most of yesterday afternoon, but I just can't get it.
The furthest I've got is rejecting everything except from letters and spaces, with each these codes individually:
(I've only listed a few so you could see just a fraction of what I'd already tried)
However, it is also rejecting hyphens, which I need it to accept.
Also, unfortunately it is accepting brackets
Hopefully someone here will have a solution, because I'm stumped,
James
I'm really struggling to try and find a solution to a problem.
I need to find a validation rule that only accepts:
letters, spaces and hyphens (-) in the field.
I have tried for at least 14 hours today and most of yesterday afternoon, but I just can't get it.
The furthest I've got is rejecting everything except from letters and spaces, with each these codes individually:
(I've only listed a few so you could see just a fraction of what I'd already tried)
Code:
Is Null Or Not Like "*[!((a-z) or (Chr(32),Chr(45)))]*"
Is Null Or Not Like "*[!((a-z) or (Chr(32)) or (Chr(45)))]*"
Is Null Or Not Like "*[!((a-z) and (Chr(32)) and (Chr(45)))]*"
Is Null OR Not Like "*[!((a-z) or ((\ ),(\-)))]*"
Is Null OR Not Like "*[!((a-z) or (\ ) or (\-)))]*"
Is Null OR Not Like "*[!((a-z) and (\ ) and (\-)))]*"
Is Null Or Not Like "*[!((a-z),\ ,\-)]*"
However, it is also rejecting hyphens, which I need it to accept.
Also, unfortunately it is accepting brackets
Hopefully someone here will have a solution, because I'm stumped,
James
Last edited: