- slide 1 of 6
Adding Finishing Touches to a Custom Switchboard Form
As discussed in Part 2 of this series, a custom switchboard form is essentially a page (database form) in your database with navigation buttons. Using the switchboard takes the drudgery out the repetitive tasks you perform with your database. In this article we will show some ways to add a more professional look to your custom switchboard form. We will demonstrate how to:
♦ add a large title to the Form Header
♦ add a graphic logo to the switchboard form
♦ customize a command button with built-in graphics
♦ turn off the form counter and navigation controls
- slide 3 of 6
To add a graphic logo to the Switchboard Form
Before you can add a logo or other graphic to a switchboard form, the graphic file must already be stored on your computer. Do the following steps:
♦ Open the form in Design view.
♦ Click on the Logo icon in the Controls Group.
♦ The Insert Picture dialog box will open.
♦ Select the graphic file. The graphic file will appear in the Form Header.
The screenshot below illustrates these steps:
- slide 4 of 6
To customize a Command Button with built-in graphics
♦ Follow Step 3 in the Bright Hub Article, “Create an Application with a Custom Switchboard.” Step through the the Command Button wizard until you reach the dialog box illustrated in the screenshot below.
♦ Select a built-in Microsoft Access button picture. (Note: You can select one of your own by clicking on the "Browse..." button and add a .bmp file stored on your computer.
The screenshot below illustrates this step:
- slide 5 of 6
To turn off the Form Counter and Navigation Controls
To disable the unnecessary form counter and navigation arrows on the custom switchboard form, do the following steps:
♦ Open the switchboard form in Design View.
♦ Open the Form Property Sheet by double clicking in the upper left hand corner below the form command ribbon.
♦ Select the Format tab/Navigation Buttons (19th item down between “Record Selectors and “Navigation Caption "). In the dropdown box in the right column, change the “Yes” to a “No.”
Microsoft Access 2007 Tips: Spruce Up Your Custom Switchboard Form
Microsoft Access 2007 switchboard forms help us streamline our database. They act as a "central hub" in accessing our forms, reports, queries, etc. This two-part series demonstrates (1) how to use the built-in wizard to automate switchboard creation and (2) how to make your own custom switchboard.