The Validation Formula lets you verify a field entry by establishing a range of acceptable values. When you enter a value in the field, DataEase checks the value to make sure that it falls within the specified range.

A Validation Formula can contain any combination of constant values, field values, lookup formulas, relational statistical operators, and any of the comparison operators (=, <, >, <=,>=, between…to, and not)

1. Open the document in Designer View, double-click on the Field object;

2. DataEase displays the “Field Definition” dialog;

3. Click on the Validation radio button. DataEase opens the Validation Formula editor;

5. Enter the Validation Formula manually, or click on a selection from the four list boxes and the numerical keypad to enter field names, relationships, functions, operators, and numbers in the formula box;

6. When you finish entering the formula, click OK. DataEase check the spelling and syntax. If DataEase finds an error, it positions the cursor at the start of the invalid word or expression. If the formula is valid, DataEase saves it as part of the field definition.

NOTE: Constant values (and any associated quotation marks) must be entered into the formula manually. If a Field Name or a relationship name is more than one word long, it must be enclosed in quotation marks. A constant text value, like the last name “Smith” must also be entered in quotation marks.

Rules for Constant Values

A constant value must follow the rules listed below, so DataEase can distinguish constants from Field Names and differentiate different types of constants.