Validation In Range

[Merit Solutions]

May seem simple but I could do with some clarification.

1. What precisely is "Always Validate" as opposed to "During data entry"

2. If I use a range given by: From "a" To "s" for example - how does this apply itself to given text input?

I understand how the range would work with numerals and dates , but text - how does this work??

thanks in advance

[CobaltSky]

Hello fumblewinter,

Some answers for you:

1. Data can arrive in a field by a number of means. By being set their from within a script - by being imported, by being entered by the user. Validation is customarily applied only to user entry. But the 'always validate option means that all possible methods by which data can be inserted into a field will be subjected to the same screening.

2. Ranges (including validation ranges) when applied to text values refer to the interceding values in a text sort order. If you were to flip open a dictionary, everything that comes between the entry for 'a' and the entry for 's' would be accepted in the example you cited and everything that comes before 'a' or after 's' would be rejected. 'Abercrombie' comes after 'a' but before 's' so it would be accepted. 'Salisbury' comes after 's' so it would be rejected.