MS Access Tab Control in Form Tables or Subform

Access Tab Control is mainly used in Form, where it organizes the form with so many controls. With Tab Control, it will possible to add two different tables or subforms into one single form.

Ms Access Tab Control (1)

Ms Access Tab Control (1)

In this tutorial, we will use a sales database, where we need to create a form to display the customer, Product sold to the customer and payment status.
To create Tab Control, follow these steps:
1. Create a new form by go to Create tab > Form Design. If the form already exist, go to the form Design view.
2. In the Blank form design view, start to design the form header.
3. After you are done with the header, now add the tab control in Design tab > Controls group > Tab Controls.

Ms Access Tab Control (2)

Ms Access Tab Control (2)

4. Now, drag to create the Tab Controls. Place it wherever you want to.
5. Click one of the tab. Open Property Sheet (F4). In Property Sheet dialog box, open All tab. In Caption row, rename the tab.
6. To fill the Tab, go to Design tab > Controls group > Subform/Subreport. Create the subform inside the tab by click it. Modify the subform as you wanted to.
7. Refine the subform display in the Tab.
8. When you create Tab Controls, it will provide 2 tabs. To add more tabs, right click one of the existing tab. Click Insert Page. To delete it, click Delete Page instead. You can change the tab order by clicking Page Order.

Ms Access Tab Control (3)

Ms Access Tab Control (3)

9. How do I change the name of a tab on a form in Access? Change the view to Form view to test the Tab Controls.
NOTE: If you already have the Tab Controls that want to be moved, just copy or cut then paste the Tab Controls into the new form.

Read Also:  MS Access VBA Close Workbook and Form

Aside Form, you can use Tab Control with Reports too. How to create Tab Control into Reports is almost same with creating one in Form. The difference is in how to create the subreport to the tab. To add the subreport, click one of the tab. Then, input the field from Field List.

Additionally, you can use the VBA code for creating Tab Control, but it might be harder since you need to learn programming skills.

Related Access Database

  • 7 tabs of ms access
  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1824 ftOli1ujoTZC8fGrlS-bcuQpTfhu5llVOLBq1Yqd_29XuyQoUqj4FEyoznc4PPiXIvCvg-1uHbrqewhnYt0XJg 755fb26fa36a64bdd44c7ff0a809d485e882ebde&uuid=&state=_BLhILn4SxNIvvL0W45KSic
  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1827 7jfr9kBZk87pra9Z7TVtI7fvDbiO8zNFZCs6LlemxVOPnhpS-8PvnXDgJGF8My-nzDUIB05SS8RVka-afdYmTw d762068b8ede39e97904285f0dc0be161c01bd2a&uuid=&state=_BLhILn4SxNIvvL0W45KSic
  • ms access tab control selected page


Access Database Tags: #7 tabs of ms access #access add subform to tab control #access tab control vba #create a tabbed form in access 2010 #how do i change the name of a tab on a form in access #ms access tab control selected page #ms access tab control subform #ms access tab control within tab control #tab control access 2013 #what is a combo box in access #what is a subform in access #what is a tab control in access

MS Access VBA Close Workbook and Form
MS Access VBA Close Workbook and Form
In this tutorial, we use Ms Access
MS Access DB and MDB Viewer Software
MS Access DB and MDB Viewer Software
Access DB Viewer is the software to
MS Access Validation Rule Lookup Table Examples
MS Access Validation Rule Lookup Table Examples
The Validation Rule in Microsoft Access is


Must read×

Top