Validation rule for alpha only

J

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".
 
D

Dirk Goldgar

JimN said:
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]*"
 
J

JimN

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

Dirk Goldgar said:
JimN said:
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)
 
D

Dirk Goldgar

JimN said:
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.
 
J

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


Dirk Goldgar said:
JimN said:
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top