Validation Rule

[JeffGeorge]

I'm not sure if this is really a form or a table issue. I have the following Validation Rule for a table field that I am using in a form. My goal is to limit the entry to 3 case-specific words.

="WAREHOUSE" Or "STORAGE" Or "QA" And <>"warehouse" And <>"storage" And <>"qa"

The only entries this form will currently accept are WAREHOUSE, STORAGE, warehouse, and storage. It won't accept QA (or even qa).

What is wrong with my logic? My goal is to allow only WAREHOUSE, STORAGE, or QA (in all caps).

[JoeM]

Not sure why you have the AND clause. Shouldn't it just be:

="WAREHOUSE" Or "STORAGE" Or "QA"

[JeffGeorge]

I had the AND because I was trying to limit it to uppercase only. I want all entries by various people to be consistent. Except that it obviously doesn't care what case is used in this instance. I don't know how to convert or limit all entries to uppercase.

[JoeM]

If all the data entry is happening through a form, I would approach this differently. Just have it automatically convert all entries to upper case as they happen.
Here is a thread which shows you a few different ways of accomplishing that: http://answers.microsoft.com/en-us/o...c-68b599b31bf5

[JeffGeorge]

That was a good tip and helped me put in a solution. Thanks!