Microsoft Access 2007: How to Create a Form Manually in Design View

Forms with a More Customized Appearance

Although the Form Wizard described in Part 1 of this series allows for an easy way to create basic new forms in Access, there are several reasons why people may prefer this more traditional way of form creation. First off, manual form creation allows for greater control over the appearance and function of your final form. You can make the form as simple or complex as you desire. In addition, once you become accustomed to creating forms, you may find the manual method an even faster solution than using the Form Wizard, especially if the form you want to create is fairly simple in nature.

In the following steps, we’ll show exactly how to make a new form in Design View without using the Form Wizard in Access. We’ll use the same sample database as we did in Part 1 of this series to demonstrate these steps.

How to Create a Form Manually in Access 2007

Step 1: After opening the database to which you would like to add a new form, select Form Design from the Create tab on the Access ribbon. (Click any image for a larger view.)

Select Form Design

This will open a blank form in Design View as shown in the screenshot below.

Design Tab in Access

Step 2: Make sure that the Design tab under Form Design Tools is open on the Access ribbon. Click on Property Sheet.

Open Property Sheet

This will open the Property Sheet panel as shown in the screenshot below.

Property Sheet Shown in Right Panel

Step 3: In the Property Sheet window, click on the tab labeled Data. From the Record Source dropdown list, select the table that contains the fields you want to include in your form.

Select Record Source

Step 4: After selecting a table, click on the Add Existing Fields button on the Access ribbon.

Add Existing Fields

Now, in the right panel, you will see a list of all available fields from the table you chose in Step 3.

Step 5: Click on a field in the Field List panel that you want to add to the form. Hold down the mouse key and drag the field to the position on the form where you want it to be located.

Click and Drag Fields

After placing the field, you can resize both the field label and content boxes by clicking and dragging the boundary boxes around the field name.

Continue this process for each field you want to add to the form. At any time during this process, if you want to get an idea of how the final form will look, click on the View button on the Access ribbon and select Form View. To return to your form design in order to make additional modifications, click View again and choose Design View.

Form View

Step 6: When finished designing the form, click the Save icon in the Quick Access Toolbar (or click the Office button and select Save). Enter a name for the form in the pop-up box that appears on the screen.

Save Form

Click OK when done, and the new form will be visible in the Forms list.

This post is part of the series: Working with Forms in Microsoft Access 2007

In this series, we’ll take a look at the different ways you can create new forms and modify existing ones in Access 2007.
  1. Creating New Forms with a Wizard in Access 2007
  2. Creating New Forms Manually in Access 2007
  3. Adding Fields to Existing Forms in Access 2007