1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Form in Table w/Fields - Tab Order

Discussion in 'Business Applications' started by sbudd, Oct 5, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. sbudd

    sbudd Thread Starter

    Joined:
    Aug 25, 2004
    Messages:
    88
    I have created a form in table format. Is there a way to change the tab order from top to bottom instead of left to right?
     
  2. cristobal03

    cristobal03

    Joined:
    Aug 5, 2005
    Messages:
    3,086
    In Datasheet View (table format), each row represents a record. The only way that you could use the tab key to move from one record to the next would be to disable the Tab Stop property of all the controls on the subform, then set the subform's Cycle property to All Records. Bear in mind, this will prevent you from tabbing into any other field than the first field in your subform, so you'd have to manually focus (i.e., click) on a control in order to edit its data.

    Why exactly do you want to do this?

    chris.
     
  3. sbudd

    sbudd Thread Starter

    Joined:
    Aug 25, 2004
    Messages:
    88
    It was the request of the form user, however, I might just tell him "no way."

    Thanks!
     
  4. cristobal03

    cristobal03

    Joined:
    Aug 5, 2005
    Messages:
    3,086
    Wow...you know, I just tested my own suggestion and even that doesn't work. The only thing I could think of, which I might maybe reluctantly consider doing--only if the form was read only--would be to capture a Tab keypress and create an event handler to move to the next record. But I'm of the opinion that writing event handlers for commonly used keys is a horrible, horrible idea.

    Though, in lieu of that, you could add a button in the form's header, default the focus to that, and use the button's event to cycle through the records. Then the user would have to use Enter instead of Tab, but it'd be pretty close.

    Anyway, just some other ideas because I'm bored.

    chris.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/404773

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice