Data Type | Abbreviation in dropdown | Description |
Character | C | A string of characters that can include any character that can be typed from the keyboard. |
Numeric | N | Decimal or integer. |
Logical | L | True or False. |
Date | D | A month-day-year date. |
DateTime | T | A date and a time. |
Character | Use |
X | Any character can be used. |
9 | Digits and signs, such as minus (-) can be entered. |
# | Digits, blanks and signs can be entered. |
$ | Displays the currency symbol. |
$$ | Displays a floating currency symbol that is always adjacent to the digits. |
* | Display asterisks to the left of the value. |
. | Specifies the decimal point position. |
, | Commas can be included to separate digits to the left of the decimal point. |
! | Force alphabet characters to uppercase. Use with character data only. |
^ | Displays numeric data using scientific notation. |
A | Allows alphabetic characters only (no spaces or punctuation marks). |
D | Uses the current date format in Windows. |
E | Display date values as British dates. |
K | Selects all the text when the control gets the focus. |
L | Displays leading zeros (instead of spaces) in the text box. |
T | Trims leading and trailing blanks from the input field. |
YS | Displays Date values in a short date format determined by the Windows Control Panel short date setting. |
YL | Displays Date values in a long date format determined by the Windows Control Panel long date setting. |
Comparison operator | Description |
Equal | Equal in a string comparison would mean anything that starts with the entered string. For example, YEA would find YEAGER and YEARLY. |
At Least | The entry must be at least this value or more. |
Greater Than | The entry must be greater than this value. |
Exactly Equal | The entry must be exactly equal to this value. For example, YEA would find only YEA. |
Less Than | The entry must be less than this value. |
Not More Than | The entry cannot be more than this value. |