Results 1 to 9 of 9

Thread: Input Mask

  1. #1
    Join Date
    May 2008
    Posts
    9

    Unanswered: Input Mask

    Im just wondering how can i use an input mask for time and date in the same field?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Set the input mask to this
    Code:
    00/00/0000\ 00:00:00
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I hate input masks
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why? Very simple way of validating user input (when used appropriately )!
    George
    Home | Blog

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yeah, it's the "when used appropriately" that annoys me. You see, most of my users are... ummm... not highly conversant or compliant to the tenants of best practice. Far too many of them STILL use their mouse and click anywhere in the field to get the focus there and with an input mask, that's bad. They start typing out their data, find that they run out of "mask" and it starts beeping, then they look at me like it's my fault. ^.^ Nup. I never use them unless it's absolutely necessary.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by StarTrekker
    Yeah, it's the "when used appropriately" that annoys me. You see, most of my users are... ummm... not highly conversant or compliant to the tenants of best practice. Far too many of them STILL use their mouse and click anywhere in the field to get the focus there and with an input mask, that's bad. They start typing out their data, find that they run out of "mask" and it starts beeping, then they look at me like it's my fault.
    Perhaps that's because you're Down Under?

    Actually, I agree totally with StarTrekker! Many developers simply can't come to grips with the fact that the way they imagine the form will be filled in and the way it actually will be filled in are seldom the same! You lay out a form in what you consider to be a logical flow of information, but the end user may not be accessing the needed data in the same order. They may, in fact, be retrieving data from several sources, and use their mice in just the manner StarTrekker described, causing the problems cited.

    I moon-lighted a number of years ago in a production data input environment, where literally thousands and thousands of records were being input in an eight-hour shift, and the biggest gripe heard was about Input Masks. People doing this type of works are frequently paid per record entered, and all of the really good producers felt that the Input Masks were distracting and slowed them down.

    A far better approach is probably formatting the data after it's been entered, using the field's OnExit or AfterUpdate event.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Perhaps that's because you're Down Under?
    I didn't know that racism was allowed here! Yank!!

    j/k

    But yeah, I validate the input by code wherever I can.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Hey, what can I say! When you flush the loo down there, the water swirls in the wrong direction!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  9. #9
    Join Date
    May 2008
    Posts
    9
    thank you worked perfectly

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •