Input Mask Characters

#

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.

A

Alphanumeric character placeholder. For example: a-z, A-Z, or 0-9. Character entry is required.

a

Alphanumeric character placeholder. For example: a-z, A-Z, or 0-9. Character entry is not required.

9

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.

C

Character or space placeholder. Character entry is not required. This operates exactly like the '&' placeholder, and makes sure compatibility with Microsoft Access.

?

Letter placeholder. For example: a-z or A-Z. Character entry is not required.

Literal

All other symbols are displayed as literals; that is, they appear as themselves.

n

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.

mm, dd, yy

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.

hh, mm, ss, tt

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.