• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Working with Forms > Organizing Forms for Efficiency

Organizing Forms for Efficiency

Most forms will have a natural order in which their fields will be visited; a form in a book-tracking database, for example, would start with the author's name, the title of the book, the publisher, and so forth. If this obvious sequence isn't what you want, you can tell Access what order you'd like to "tab" the fields in.

To establish a tab order:

1.
In Design view, open the form in which you want to set a tab order.

For this example we're using the Books table from the Books database.

2.
Choose View > Tab Order.

3.
In the Tab Order dialog box, select the row selector of the control you want to move and drag it to the desired position ( Figure 4.15 ).

Figure 4.15. Open the Tab Order dialog box and click the control you want to change.


In this instance, we want to move the Notes field from its current location closer to the end of the tab order. Although most of the other data can be transcribed directly from the book itself, notes require a bit more thought, and should be reserved for the end of the data entry process.

When you release the left mouse button, the control appears in its new place in the order ( Figure 4.16 ).

Figure 4.16. Then drag it to its new place in your form's tab order.


Tip

To have Access automatically assign a tab order (based on an up-down or left-right reading of your form), display the Tab Order dialog box and click the Auto Order button.


Tip

If you have controls in more than one section of your form, click the option button next to the section in which you want to set a tab order.


Tip

You can exclude a control from the tab order by setting its Tab Stop property to "No." To return it to the order, change the Tab Stop property to "Yes." (The control doesn't disappear from the form, it just can't be tabbed to.) For information about setting a control's properties, see "Specifying Properties in Forms," later in this chapter.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint