Access Controls  «Prev  Next»

Creating Multipage Forms - Exercise Result

You entered:

Course project: Adding a Tab control to a form

You needed to add a Tab control to one of your client's forms. Page 1 should look something like this:

Page 1 result
The diagram above shows a Microsoft Access form with a tab control interface.
The form has two tabs: Main Information and Projects. Below are the labels visible on the form under the Main Information tab:
  1. Company
  2. FirstName
  3. LastName
  4. Address
  5. City
  6. State
  7. Zip

These labels correspond to fields on the form used to input or display specific data related to clients.
Network Consultants, Inc.

Page 2 should look something like this:


Page 2 result
The image shows a Microsoft Access form with the Projects tab selected. In this tab, there is a datasheet-style subform or control displaying project information. The visible label on this form is:
  • ProjectDescription
    This label corresponds to the column header in the datasheet that lists various project descriptions. If you need further assistance or analysis, let me know!
Marketing description of consultants

Tab Control Displays several tabs of information. You can see the content in one tab at a time, you click to pick which tab you want. This Windows staple lets you pack more information into a smaller space.

Organizing with Tab Controls

One of the control world's overlooked features is the tab control, which lets you present large amounts of content in a limited space. The tab control's feature is the way it lets you organize this content into separate pages. You can see only one page at a time, and you choose which one by clicking the corresponding tab.

Disadvantages of Tab Control

Its main drawback is that you need to use extra clicks to get from one tab to another. For that reason, the tab control is not a great choice in forms that you have set up to create new records.
In those instances it is better so you can move through them quickly. A tab control makes most sense in forms that are primarily designed for editing or reviewing data. If this data can be subdivided into logical groups, and if editing tasks often involve just one group, then the tab control is a good choice.

To use a tab control, follow these steps:
  1. In the ribbon's Form Design Tools | Design.Controls section, click the Tab Control.
  2. Draw the tab control onto your form in the place you want it. You will want to make it fairly large, so it can accommodate the content you will place inside.
  3. Add all the tab pages you need. Every new tab control starts with two pages. You can move from page to page by clicking the correct tab. To create a new page, right-click any tab and choose Insert Page. To remove an existing page, right-click it and choose Delete Page.
  4. Give the tabs good names. The tabs that Access creates start out with pointless names like Page19 and Page20. To change the name, select the page, and then change the Caption setting in the Property Sheet. The page that displays customer address fields could have the caption "Address Information". To rearrange your pages, right-click the tab control, and then choose Page Order. Access opens a Page Order dialog box with a list of tabs. To change the order of a tab, select it, and then click Move Up or Move Down.