Field Suffix | Value Attribute | Description |
_required | Custom error message | Verifies that some entry is made by the user |
_integer | Custom error message | Verifies that a number is entered by the user. If user enters a floating point value it is rounded to an integer. |
_float | Custom error message | Verifies that a number is entered by the user. Does not round floating point values. |
_range | MIN=MinValue MAX=MaxValue | Verifies that the numeric value entered is within the specified boundaries. You can specify one or both of the boundaries (MIN and MAX). |
_date | Custom error message | Verifies that a date of one of the following formats is entered by the user: MM/DD/YY, MM/DD/YYYY |
_timetime | Custom error message | Verifies that a time has been correctly entered and converts the time to the proper ODBC time format. |
_eurodate | Custom error message | Verifies that a date has been entered in a standard European date format and ODBC date format. |
_Postal | Custom error message | Verifies that a postal code (Canada) is in the correct format (A#A #A#) |
_CCNum | Custom error message | Verifies that a credit card number has been entered in the correct format. Checks VISA, AMEX and MasterCard numbers. |
_NAPhone | Custom error message | Verifies that a North American (###-###-####) phone number has been entered in the correct format. |
_LenRange | MIN=MinValue MAX=MaxValue | Verifies that the length of the field is within the specified boundaries. You can specify one or both of the boundaries (MIN and MAX). |
_UnPad | Custom error message | This trims the left and right blank spaces from the variable. |
_NoSQL | Custom error message | Verifies that the data does not contain, DELETE, INSERT, SELECT, DROP, CREATE, or UPDATE, EXEC |
_Positive | Custom error message | Verifies that the number entered is a number greater that or equal to zero. |
_Negative | Custom error message | Verifies that the number entered is a number less than zero. |