Validate

Disable Validation

You can create non-validating Lookup tables. To do this make sure that Enable validation is not selected in the Compile form. This can be useful when you create validation tables with Contents.

When there are many permutations and validation is on, this type of Lookup table can become quite large. Switching validation off will mean file size is greatly reduced in these circumstances.

Validation Options

You can also control the default validation behaviour of Lookup tables by making changes in the Options | System | Editor Options form, on the Lookup Table tab. (Click the Project tab to open the backstage menu.).

• Select "Validate Lookup Fields" to validate a code when you leave the cell where it is entered.
• Select "Validate Lookup Fields" and "Validate each keystroke" to validate a code as you enter each character.
• Do not validate - clear the "Validate Lookup Fields" option.

If you only use the Lookup table menus to select codes, then it is not possible to enter an invalid code, however you can still manually enter an invalid code. The validation features of Lookup tables come into play when a code or a partial code is manually entered.

You can control how the application behaves when an invalid code is entered. If you have selected the "Validate each keystroke" option, only the first of the following three options is relevant:

• Select the "Valid input compulsory" option to issue a warning message.
• Select the "Flag (prefix) with" option and enter a prefix, to prefix an invalid code with a string of characters that you define.
• Select the "Flag (replace) with" option and enter a replacement code, to replace the invalid code with a string of characters that you define.