Alpha only field

P

PCF Parks

in table creation how can I format a field to allow ALPHA characters only.
No numeric Thank you
 
J

John Nurick

Set the field's validation rule to something like this, which excludes
non-alpha characters but allows nulls:

Not Like "*[!A-Z]*" Or Is Null

On Thu, 19 Jan 2006 07:27:05 -0800, PCF Parks <PCF
 

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

Mail Merge Directory Conditional Page Break 0
adding alpha numeric autonumber field to Access 1
What is this called in Excel or how it works? 0
data validadtion 8
in table design format field for alpha only 3
Setting a range in a named range 3
Hyperlinks with lookups 0
Macro to select and delete levels of a document 2

Top