Validation Rule

[Mac_Wood]

Hello,

I want to restrict data entry to a three letter code. It must be letters and not numbers. I am entering the rule at table level so that should I pass the db onto someone else the rule remains in place even if somebody creates a new user interface. Thank you

 

[DevastatioN]

There is an article here explaining how to do this:

http://support.microsoft.com/kb/210385

I would just use an input mask of only allowing 3 letters, and then setting the text size to 3, if this suits your needs.

 

[Mac_Wood]

Thanks Devastation. Didn't understand the kb article but used the input mask.