Validation rule for alpha only

[JimN]

Is there validation rule to prohibit non-alpha characters to be entered into
a field? Square bracket "[" can now be entered into a field mistakenly for a
"p".

 

[Dirk Goldgar]

Is there validation rule to prohibit non-alpha characters to be
entered into a field? Square bracket "[" can now be entered into a
field mistakenly for a "p".

Try this as the validation rule:

Not Like "*[!a-z ]*"

That's assuming you want to allow the space character also. If you
don't want to allow spaces, use this:

Not Like "*[!a-z]*"

 

[JimN]

Hey Dirk, Both rules look alike! Hope you got the Red cross notification.
JimN

Is there validation rule to prohibit non-alpha characters to be
entered into a field? Square bracket "[" can now be entered into a
field mistakenly for a "p".

Try this as the validation rule:

Not Like "*[!a-z ]*"

That's assuming you want to allow the space character also. If you
don't want to allow spaces, use this:

Not Like "*[!a-z]*"

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Hey Dirk, Both rules look alike! Hope you got the Red cross
notification. JimN

The first one has a space before the closing "]".

Is that Jim Nessl? I did, and sent a message to your Hotmail account,
saying how very much I appreciated your thoughtfulness and generosity.
It's the best reward I've ever gotten for doing what I do.

 

[JimN]

You deserved more in my estimation, I was beginning to panic as the users
were getting restless. And now I must than you again, have a great day.
Jim Nessl

Hey Dirk, Both rules look alike! Hope you got the Red cross
notification. JimN

The first one has a space before the closing "]".

Is that Jim Nessl? I did, and sent a message to your Hotmail account,
saying how very much I appreciated your thoughtfulness and generosity.
It's the best reward I've ever gotten for doing what I do.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)