input mask

[berni]

hello,
how can i format one field table "ItemID" using the
InputMask property to display data as follow:
Exemple:

F_0001

i couldn't get the underscore character to show.
thks,

 

[Al Campagna]

Berni,
Try this input mask...
L\_AAAA
L = User must enter an Alpha character...
\_ = causes an underscore to be entered...
AAAA = User must enter 4 Numeric digits.

 

[Kevin Sprinkel]

how can i format one field table "ItemID" using the

InputMask property to display data as follow:
Exemple:

F_0001

i couldn't get the underscore character to show.
thks,

Put the \ character before the underscore in the input
mask. This example capitalizes initial character, and
requires the character and all four digits:

L\_0000

Best regards.

Kevin Sprinkel
Becker & Frondorf

 

[berni]

thks for replying.
it works. my mistake was that i also used the Format
property to format the table field with uppercase. it
seems that the format property overwrite the input
property.
thks anyway for being so kind.

 

[Al Campagna]

Berni,
My mistake... L\_0000 is the correct input mask. (0s for 4 required
digits)