Microsoft KB Archive/208785

= ACC2000: How to Use the Tab Control in Access =

Article ID: 208785

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208785



This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
This article demonstrates how to use the tab control on a form in Microsoft Access.



MORE INFORMATION
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

A tab control is the easiest and most effective way to create a form with multiple pages or multiple embedded subforms.

With a tab control, you can build separate pages into one control. To switch pages, you click one of the tabs on the control. To see an example of a multi-page form that uses the tab control, open the Employees form (not the Employees (Page Brake) form) in the sample database Northwind.mdb or in NorthwindCS.mdb.

The following steps show you how to create a form with a tab control, where the tab control is a container for multiple subforms. This example uses the sample database Northwind.mdb, but you could do this in the sample Access project NorthwindCS.adp as well:  Open the sample database Northwind.mdb.  Create a new form not based on any table or query in Design View, and name it My Switchboard:   Form: My Switchboard Width: 6"

Detail Section: Height: 5"  Label:   Caption: Switchboard   Left: 2" Top: .5"  Width: 2" Height: .5"  FontSize: 24                     Click the Tab Control button in the toolbox, and then click somewhere below the label on the form. Microsoft Access adds a tab control with two pages to the form.  Set the following properties for the tab control:    Left: .25" Top: 1"  Width: 5.5" Height: 4"                    Right-click the left tab on the tab control, and then click Insert Page on the menu that appears. This adds a third tab to the control.</li> Click the left tab on the tab control and set its Caption property to Employees.</li> Click the Subform/Subreport button in the toolbox. If the property sheet is not displayed, on the View menu, click Properties, and then set the AutoLabel property to No.</li> Press F11 to bring the Database window to the foreground, and position the windows on the screen so that you can see the Employees form in the Database window as well as the tab control on the My Switchboard form.</li> Drag the Employees form from the Database window to the tab control. The Employees form becomes a subform object on the tab control.</li>  Set the following properties for the new subform object: <pre class="fixed_text">  Left: 0"   Top: 1.25" Width: 6"  Height: 4" NOTE: Some of these properties may force a minimum default value. For example, Left may default to a minimum value of .0938". </li> Click the center tab on the tab control and set its Caption property to Orders.</li> Repeat steps 8 and 9 with the Orders form.</li>  Set the following properties for the new subform object: <pre class="fixed_text">  Left: 0" Top: 1.25"  Width: 6" Height: 4" NOTE: Some of these properties may force a minimum default value. For example, Left may default to a minimum value of .0938". </li> Click the right tab on the tab control and set its Caption property to Products.</li> Repeat steps 8 and 9 with the Products form.</li>  Set the following properties for the new subform object: <pre class="fixed_text">  Left: 0"   Top: 1.25" Width: 6"  Height: 4" NOTE: Some of these properties may force a minimum default value. For example, Left may default to a minimum value of .0938". </li> Click the Subform/Subreport control in the toolbox, and then set its AutoLabel property back to Yes.</li> Save the form, open it in Form view, and maximize the window. Click the different tabs at the top of the tab control and note that the Employees, Orders, and Products forms are displayed.</li></ol>

<div class="references_section">