Field validation multiple choice

[rjstephan]

I have a field I want to validate to contain one or more of only five specific words, ie, red, green, blue, white, yellow. The IN expression requires ONE of a list, but I want to be able to have more than one from the list, but always only from the list. Example of Color Field in: Record 1 - blue; Record 2 - blue green; Record 3 - (cannot enter black). What is the proper macro/expression/formula to achieve this?

 

[dynamictiger]

In the validation rule for the field on table design view type something like:
"Red" Or "Green" Or "Blue" Or "Yellow"

In the Validation text type some message like:

You may only choose Red, green, blue or Yellow.

 

[rjstephan]

You missed the difficult part -- having more than one of the valid words in the field. Your method only allows one of the possible words, but not two or three. Got a better solution?

 

[dynamictiger]

Two fields