Validation Rule to allow hyphen, exclude other special characters 1

[mlev]

I'm a bit confused on how to properly format a validation rule for an Access form. The rule I've been using to exclude special character is:

Is Null Or Not Like "*[!((a-z) or (0-9) or (.))]*"

I copied that from a site online and I'm not sure why the double-negative is necessary, but it does work.

The problem is that now I need to allow users to input a dash or hyphen "-" and I can't seem to add that in. Obvious things like this do not work:

Is Null Or Not Like "*[!((a-z) or (0-9) or (-) or (.))]*"

Any assistance is appreciated. Would a module with a function for validation work better for this purpose?

 

[PHV]

Something like this ?
Is Null Or Not Like "*[!-a-z0-9.]*"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mlev]

You are my hero!!