While defining a field or table column in the Design view, you can specify a list as part of validation option for a selected field or table column. The extracted value of the field is validated against this predefined list during Preview and Test Run.
You can only specify list validation when format of field or table column is "Text". If the lookup returns multiple values for a word, the value is not auto corrected and the validation fails.
To specify list validation, do the following:
- Select the validation type as List from the Validate drop-down menu.
Type a predefined list and click Define to save.
Each value in the list should be in a separate line.
If the extracted value does not match any value in the predefined list, the field is considered to have failed validation.