Results 1 to 3 of 3
  1. #1
    Remster is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    317

    Input mask frustration (decimals)

    Folks



    I have the following input mask in a form:

    00.00;;_

    When the cell is selected, the following is displayed:

    __.00

    But I want this to be displayed:

    __.__

    What am I doing wrong? I've tried various things with the format and the field size.

    Remster

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    masks are just like PHP in one way: they use the 'backslash' as an escape character.

    so, to tell Access that a character is literal, use: "\". your mask would be:
    Code:
    00\.00

  3. #3
    Remster is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    317
    Seems to work!

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

Similar Threads

  1. Phone Input Mask issue
    By Huddle in forum Forms
    Replies: 4
    Last Post: 08-13-2010, 03:02 PM
  2. Newbie input mask Q and paswords setting
    By Cincity in forum Programming
    Replies: 2
    Last Post: 08-01-2010, 12:42 AM
  3. day of week input mask
    By jacko311 in forum Programming
    Replies: 7
    Last Post: 11-15-2009, 12:56 PM
  4. Input Mask for an IP Address and Mack Address
    By baksg1995 in forum Access
    Replies: 18
    Last Post: 06-23-2009, 12:33 PM
  5. Input mask
    By doobybug in forum Access
    Replies: 2
    Last Post: 06-17-2009, 09:40 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