Re: Custom Input Mask

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: StCyrM (stcyrm_at_aol.com)
Date: 10/29/04


Date: 29 Oct 2004 17:27:27 GMT

Good afternoon

Here are all of the rules for input masks.

Hope this is of some help to you.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
Ottawa, Ontario

Character Description

0 Digit (0 through 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; blank positions converted to spaces, plus
and minus signs allowed).
L Letter (A through Z, entry required).
? Letter (A through 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 thousands, date, and time
separators. (The actual character used depends on the regional settings
specified by double-clicking Regional Settings in the Windows Control
Panel.)

< Causes all characters that follow to be converted to lowercase.
> Causes all characters that follow 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 a literal
character. Used to display any of the characters listed in this table as
literal characters (for example, \A is displayed as just A).

Password Setting the InputMask property to the word Password creates a
password entry text box. Any character typed in the text box is stored as
the character but is displayed as an asterisk (*).



Relevant Pages

  • Re: telephone number format question
    ... If you type input mask into Access help there is substantial info on ... (The actual character used depends on the regional settings ... You can include the exclamation point anywhere in the input mask. ... Used to display any of the characters listed in this table as ...
    (microsoft.public.access.formscoding)
  • RE: Data input
    ... Digit or space (entry not required; plus and minus signs not allowed). ... C Any character or a space. ... Causes the input mask to display from right to left, ...
    (microsoft.public.access.gettingstarted)
  • Re: Select Method from Combo Box
    ... Have you set the matchentry property to 1 (FmMatchEntryComplete). ... of characters that match exactly one entry in the list. ... > It will only allow me to type one character. ... >> Private Sub UserForm_Initialize ...
    (microsoft.public.excel.programming)
  • Re: input mask
    ... > L Letter (A through Z, entry required). ... > C Any character or a space. ... Causes the input mask to display from right to left, ...
    (microsoft.public.access.gettingstarted)
  • Re: Ranges
    ... I am trying to figure out how I can find out if a character ... A text box entry might need to be first converted to numeric entry for you ... Dim MyNumber as Integer ... This enables you to set a pattern and match ...
    (comp.programming)