Validating to only except text

[stevey03]

Just wondering if anyone knew how to set up a validation rule on a field to only accept letters. for example the field in question is a staff member's name field, and I have it set to text, but I don't want any numerical characters in the field.

Anyone got any ideas?

Steve

 

[Norie]

Steve

Do you not have a list/table of staff member's names?

If you do you could use it to create a ccombobox lookup and only allow values in that list.

 

[stevey03]

Hi Norie!

No I haven't, It's more for when registering the member of staff to hold their details on the database.

Steve

 

[Norie]

Steve

It is possible but would probably require creating a user defined function.

Here is a thread that deals with similar issue, but for textboxes on userforms IF NOT ISTEXT OR BLANK...

 

[stevey03]

Thats great, I'll have a look right now. Thanks Norie!

 

[Andrew Fergus]

Hi Steve
Just a thought on your text validation problem, there is a way of excluding just numerical characters which involves using something like this in your field validation rule :

Not Like "*0*" And Not Like "*1*" And Not Like "*2*" ....... And Not Like "*9*"

This will prevent numbers from being entered into the field but won't prevent punctuation marks etc. A little clunky I know but less clunky than testing for Like "*A*" ... to ... Like "*Z*" - I'm not sure if that would fit into the validation box anyway, but it could be worth a try.

My 2c
Andrew

 

[stevey03]

That's done it. Worked like a treat. Cheers Andrew.