Input Mask Help 1

[iamedwardkim]

I currently have an input mask that allows two numbers followed by a hyphen followed by three more numbers and it looks like this: 00\-000;0;_

However, I would like the three numbers following the hyphen to also accept the letters in the alphabet. Does anybody know what I should do to my input mask?

Thank you.

 

[nat1967]

Hi,

I would suggest looking up InputMask in the help file. You have several choices that you can use. Here is a a section from the help file.
*********************
Character Description
0 - Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed).
9 - Digit or space (entry not required, plus and minus signs not allowed).
# - Digit or space (entry not required; spaces are displayed as blanks while in Edit mode, but blanks are removed when data is saved; plus and minus signs allowed).
L - Letter (A to Z, entry required).
? - Letter (A to Z, entry optional).
A - Letter or digit (entry required).
a - Letter or digit (entry optional).
& - Any character or a space (entry required).
C - Any character or a space (entry optional).
. , : ; - / Decimal placeholder and thousand, date, and time separators. (The actual character used depends on the settings in the Regional Settings Properties dialog box in Windows Control Panel).
< - Causes all characters to be converted to lowercase.
> - Causes all characters to be converted to uppercase.
! - Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask.
\ - Causes the character that follows to be displayed as the literal character (for example, \A is displayed as just A).
**************************

HTH Have A Great Day!!!,

Nathan
Senior Test Lead

 

[iamedwardkim]

Thank you, I should've checked the help files first. The 'A' character did the trick.