In Statement

[tobe]

Sometimes there is no simple formula to define valid data, but there is a list of valid values. For example, you might require a state code in a U.S. postal address to be one of the 50+ that the U.S. Postal Service recognizes, or you might require a department name to be one of those in your company.


The simplest way to handle this is to list them in the rule. The expression “IN (a, b, c,…)” does this. This evaluates as True if the entered value is a, b, c, up to as many as you have. (Replace a, b, c and so on with the valid values.) If items are text, put them in quotation marks. A rule to see if a location is one of your firm's offices might look like this:

IN (“Boston”, “Paris”, “Sydney”, “Santiago”) I want to know how to do this for long list maybe just using a table?

[pbaldy]

Typically I'd use a combo that got its selections from a table, and set Limit to List to Yes.