Option A makes available all three validation methods listed below; Option B makes the first two available.
Tip |
---|
A data description for the column is displayed when you hover the mouse over a cell or click in a cell. Use this feature if you are unsure of why a cell failed validation. |
...
- As you are entering data into a form, the program validates your entries.
- If an entry fails validation, the program displays a pop-up dialog describing the error; the cell color is also set to pink after you click OK in the dialog and the cursor returns to the field. Sometimes the invalid entry is erased.
On Option B forms a warning message, “One or more cells contain Invalid Entries”, will appear in the header area of the form.
- You do not need to correct the error to continue entering data in the form, but should correct all errors before submitting your report.
...
- When you save the file, the program asks whether you would like to validate the file first.
- If you choose Yes, cells which do not pass validation will be displayed with a pink background.
- Find and correct the highlighted cells.
- At any time you can validate the data you have entered by clicking the Validate menu item.
- If there are errors, the program displays a dialog with the error count and highlights all cells.
- Find and correct the highlighted cells.
...