Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Entering Negative Numbers Using Input Masks (2003)

    I'd like the end user to be able to enter data in a text box on the startup form of the attached mdb without having to input the decimal separator every time. The text box must have three characters before the decimal point and two afterwards.
    The input mask definition ###.## serves the purpose but what if the user wants to have the ability to input a negative number?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Entering Negative Numbers Using Input Masks (2003)

    The Input Mask in Access has limited functionality. It does not really provide for what you want.

    You could set an input mask ####.##, the first character can be used to enter the minus sign. Of course, this will allow the user to enter positive numbers with 4 digits before the decimal separator, so you'd have to check for that in the Before Update event.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Entering Negative Numbers Using Input Masks (2003)

    ...and with the ####.## setting, every time the user starts entering the customary three+two digits, he/she has to press the space bar to move to the second position.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Entering Negative Numbers Using Input Masks (2003)

    I don't know of a solution for that - as I wrote, the Input Mask in Access is limited compared to that in some other applications.

Posting Permissions

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