Results 1 to 3 of 3
  1. #1
    starlev is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    6

    Input mask wizard postal code and not zip for an option.

    Hi.
    When I go to input mask wizard.
    I have postal code and not zip for an option.
    I think my Access is set to work UK and not USA how can I change this?

    In order to explain the question better I am attaching a word document with the menu I currently have and what I would like to have.



    Thank you in advance for your help

  2. #2
    LaughingBull is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    Jul 2015
    Location
    Toledo Ohio
    Posts
    143
    You can create your own input mask. when you open input mask on the bottom left it says edit list click on that and create the new mask.
    Mask Character Meaning
    0 A single digit must be entered in this position.
    9 A digit or a space can be entered in this position. If the user skips this position by moving the
    cursor past the position without entering anything, Access stores nothing in this position.
    # A digit, a space, or a plus or minus sign can be entered in this position. If the user skips this
    position by moving the cursor past the position without entering anything, Access stores a
    space.
    L A letter must be entered in this position.
    ? A letter can be entered in this position. If the user skips this position by
    moving the cursor past the position without entering anything, Access
    stores nothing.
    A A letter or a digit must be entered in this position.
    a A letter or a digit can be entered in this position. If the user skips this
    position by moving the cursor past the position without entering anything,
    Access stores nothing.
    & A character or a space must be entered in this position.
    C Any character or a space can be entered in this position. If the user skips
    this position by moving the cursor past the position without entering anything,
    Access stores nothing.. Decimal placeholder (depends on the setting in the regional settings in
    Windows Control Panel).
    , Thousands separator (depends on the setting in the regional settings in
    Windows Control Panel).
    : ; - / Date and time separators (depends on the settings in the regional settings
    in Windows Control Panel).
    < Converts to lowercase all characters that follow.
    > Converts to uppercase all characters that follow.
    ! Causes the mask to fill from right to left when you define optional characters
    on the left end of the mask. You can place this character anywhere in
    the mask.
    \ Causes the character immediately following to be displayed as a literal
    character rather than as a mask character.
    “literal” You can also enclose any literal string

  3. #3
    starlev is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    6
    Thank you that works.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Input Mask
    By kdbailey in forum Access
    Replies: 4
    Last Post: 12-19-2014, 08:11 AM
  2. Input mask
    By scorpion99 in forum Access
    Replies: 4
    Last Post: 02-21-2014, 02:18 AM
  3. Combo Box Wizard does not have option form option
    By CementCarver in forum Forms
    Replies: 5
    Last Post: 02-28-2013, 08:54 PM
  4. UK Postcode/ZIP Code Input Mask
    By tsn.s in forum Access
    Replies: 1
    Last Post: 04-02-2012, 05:49 AM
  5. Input Mask
    By qbc in forum Access
    Replies: 2
    Last Post: 01-20-2012, 03:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums