Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Textbox Control (XL97; SR2)

    How does one control the flow of data entered into textboxes of a form. I have a typical UserID/Password form and when I enter the UserID and press the tab key, the cursor moves to the "OK" button not the second textbox (password entry box).

    John

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Form Textbox Control (SL97; SR2)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> jstevens

    Look into the Tab Order.

    Right-Mouse-Click on the form, and then scroll down to Tab Order. You will get a dialog where you can move the control names up and down.

    First one gets focus first, second gets it after the tab key, and third follows and so on.

    This is called focus, if a control has the focus, then it is the one you can work with.

    See my earlier post <!post=SetFocus Trouble???,277234>SetFocus Trouble???<!/post> for some headaches you may encounter.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Textbox Control (XL97; SR2)

    Trial and Error pays off!

    Set the TabIndex property of Textbox1 to 1 and TabIndex of Textbox2 to 2.

    John

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Textbox Control (XL97; SR2)

    I don't have Excel 97 running, but I believe that you should be able to find a Property called Tab Order - which controls which sequence the Tab Key moves through the Controls. HTH
    Gre

Posting Permissions

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