Field Validation Rule

O

oscar

What is the code to validate a text field to be alpha
only? Any sites with examples of validation rules and
field formatting?
 
M

Michel Walsh

Hi,



NOT LIKE '*[0123456789]*'



include all the characters you do not want to see (here, I assumed just
digits were forbidden).




Hoping it may help,
Vanderghast, Access MVP
 

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

Similar Threads

Compile Error. in table-level validation expression in append query 0
Validation Rule 2
Mail Merge Directory Conditional Page Break 0
How to use validation values stores in a second table? 3
Validation rule problem 11
Validation Rules for a Control on a Form (?) 4
Please put "crossposting not allowed" in the rules 0
Multiple Validation Expressions 9

Top