|
Digit placeholder. Character must be numeric (0-9) and entry is required.
|
|
Decimal placeholder. The actual character used is the one specified as the decimal placeholder by the system’s international settings. This character is treated as a literal for masking purposes.
|
|
Thousands separator. The actual character used is the one specified as the thousands separator by the system’s international settings. This character is treated as a literal for masking purposes.
|
|
Time separator. The actual character used is the one specified as the time separator by the system’s international settings. This character is treated as a literal for masking purposes
|
|
Date separator. The actual character used is the one specified as the date separator by the system’s international settings. This character is treated as a literal for masking purposes.
|
|
Treat the next character in the mask string as a literal. This allows you to include the '#', '&', 'A', and '?' characters in the mask. This character is treated as a literal for masking purposes.
|
|
Character placeholder. Valid values for this placeholder are ANSI characters in the following ranges: 32-126 and 128-255 (keyboard and foreign symbol characters).
|
|
Convert all the characters that follow to uppercase.
|
|
Convert all the characters that follow to lowercase.
|
|
Alphanumeric character placeholder. For example: a-z, A-Z, or 0-9. Character entry is required.
|
|
Alphanumeric character placeholder. For example: a-z, A-Z, or 0-9. Character entry is not required.
|
|
Digit placeholder. Character must be numeric (0-9) but entry is not required.
|
|
Optional minus sign to indicate negative numbers. Must appear at the beginning of the mask string.
|
|
Character or space placeholder. Character entry is not required. This operates exactly like the '&' placeholder, and ensures compatibility with Microsoft Access.
|
|
Letter placeholder. For example: a-z or A-Z. Character entry is not required.
|
|
All other symbols are displayed as literals; that is, they appear as themselves.
|
|
Digit placeholder. A group of n’s can be used to create a numeric section where numbers are entered from right to left. Character must be numeric (0-9) but entry is not required.
|
|
Combination of these three special strings can be used to define a date mask. mm for month, dd for day, yy for two digit year and yyyy for four digit year. Examples: mm/dd/yyyy, yyyy/mm/dd, mm/yy.
|
|
Combination of these three special strings can be used to define a time mask. hh for hour, mm for minute, ss for second, and tt for AP/PM. Examples: hh:mm, hh:mm tt, hh:mm:ss.
|