Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    17

    Unanswered: input mask problem..

    hello guys,

    i started to pull out my hair on this.

    i have 2 unbound text boxes.
    on the first box, you must input between "00.01" and "99.99" and the second box must input between "0.01" and "9.99". now, if the user's input on the first box is "92" and presses the enter key it will automatically display like this "92.00" or if the entry is "92.00" the focus will set to 2nd text box. same as 2nd textbox.



    i tried "Input Masks" but you have to complete all the data and you cannot use the enter key. and also "Format()" but i think i miss some thing.


    thanks in advance.

  2. #2
    Join Date
    Mar 2009
    Posts
    17
    well i think nobody knows how to do it.
    thanks

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    put some code in a function to validate the input.
    place a call to that function in the controls before validate and on lost focus events
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Mar 2009
    Posts
    17
    thanks healdem for your response

    sorry, im not that good in access or vb, but willing to learn.
    could you please give me some example of function on how to do this?

    Please.....

Posting Permissions

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