Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unhappy Unanswered: PLEASE HELP Inputmask

    Somebody must know this!? It is not difficult, but for me it is...

    Please help me!

    I am trying to make an inputmask in a MS Acces database for dutch phone numbers. But it does not work.

    This is the inputmask: !999/-0000000

    When I enter the number 1799444 it gives a error message. The ! in the inputmask should make this kind of input possible?! Am I wrong?

    Can somebody help me?

    Thanks a lot...

    (I am using MS Access 2003 by the way)

  2. #2
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303
    1) I think you want your slash to go the other way.
    !999\-0000000

    2) When you type in the number, you have to be in the correct position in the control. That is, if you begin typing the number at the left most position, it will require the final three digits (giving the user an error). However, if you position the cursor after the hyphen, and then enter only seven digits, all is well.
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

  3. #3
    Join Date
    Feb 2004
    Posts
    3
    Originally posted by jpshay
    1) I think you want your slash to go the other way.
    !999\-0000000

    2) When you type in the number, you have to be in the correct position in the control. That is, if you begin typing the number at the left most position, it will require the final three digits (giving the user an error). However, if you position the cursor after the hyphen, and then enter only seven digits, all is well.

    Stupid ofcourse the / must be \ but Why is the ! in the inputmask?
    I thought that this causes the input from right to left. In that way you can enter 3911233 as a valid entry. But with or without the ! it is always filled from left to right. In that way 3911233 is not a valid entry. Strange!

    Do you know how the ! works? Do I not understand ! correct?

  4. #4
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303
    Sorry. I looked at the help. I expected the same thing you did.

    Look at the property called "reading order" under the format tab of the property box. That may help.

    I am still unsure about the use of the !
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

Posting Permissions

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