RE: Data input

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

Hi

This is copied from the F1 help

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 in
Microsoft 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 (*).

--
Wayne
Trentino, Italia.



"rsenn" wrote:

I'm working on my first table. I'm a raw rookie.

I'm trying to define a field which would

have up to 6 alpha numeric characters (no special characters), and
would right align at input, even if left aligned as entered, and
and would allow no embedded spaces (leading spaces are okay).

How can I set up an input mask or otherwise do this?
.

Relevant Pages

  • Re: How can I create a mask that will put ************1234 for a cred.
    ... Digit or space (entry not required; plus and minus signs not allowed). ... & Any character or a space. ... Causes the input mask to display from right to left, ...
    (microsoft.public.access.modulesdaovba)
  • 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: Custom Input Mask
    ... 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, ... You can include the exclamation point anywhere in the input mask. ...
    (microsoft.public.access.forms)
  • 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)