Create a split form

A split form is a new feature in Microsoft Office Access 2007 that gives you two views of your data at the same time — a Form view and a Datasheet view. The two views are connected to the same data source and are synchronized with each other at all times. Selecting a field in one part of the form selects the same field in the other part of the form. You can add, edit, or delete data from either part (provided the record source is updateable and you have not configured the form to prevent these actions).

Split Form

Working with split forms gives you the benefits of both types of forms in a single form. For example, you can use the datasheet portion of the form to quickly locate a record, and then use the form portion to view or edit the record. The form portion can serve as an attractive and functional header for the datasheet portion. This technique is used in many of the template databases that are available for Office Access 2007.

What do you want to do?


Create a new split form by using the Split Form tool

This procedure creates a new split form from scratch. The form is based on a table or query that you select from the Navigation Pane or have open in Datasheet view.

  1. In the Navigation Pane, click the table or query that contains the data that you want on your form. Or open the table or query in Datasheet view.
  2. On the Create tab, in the Forms group, click Split Form Button image. Button image

Access creates the form and displays it in Layout view. In Layout view, you can make design changes to the form while it is displaying data. For example, you can adjust the size of the text boxes to fit the data, if necessary.

Top of Page Top of Page

Turn your existing form into a split form

You can turn your existing form into a split form by setting a few form properties.

  1. Open your form in Design view by right-clicking it in the Navigation Pane and then clicking Design View.
  2. If the property sheet is not already displayed, press F4 to display it.
  3. Select Form from the drop-down list at the top of the property sheet.
  4. On the Format tab of the property sheet, in the Default View drop-down list, select Split Form.
  5. Check your form in Form view. To switch to Form view, double-click the form name in the Navigation Pane.

Top of Page Top of Page

Fine-tune your split form

After you create your split form, you can make some adjustments in Design view or Layout view to get the results you want.

Set the split form properties

The following table lists some of the properties that are related to split forms that you can set on the property sheet to fine-tune your form. If the property sheet is not already displayed, press F4 to display it. Also, ensure that Form is selected in the drop-down list at the top of the property sheet. All of the properties in the table are located on the Format tab of the property sheet.

Property View(s) in which you can set the property Description
Split Form Orientation Design view only Allows you to define whether the datasheet appears above, below, to the left, or to the right of the form.
Split Form Datasheet Design view or Layout view If set to Allow Edits (and the form's record source is updateable), Access allows edits to be made on the datasheet. If the property is set to Read Only, Access prevents edits from being made on the datasheet.
Split Form Splitter Bar Design view only If set to Yes, Access allows you to resize the form and datasheet by moving the splitter bar that separates the two parts. You can drag the splitter bar to provide more room or less room for the datasheet. If this property is set to No, the splitter bar is hidden, and the form and datasheet cannot be resized.
Save Splitter Bar Position Design view only If set to Yes, the form opens with the splitter bar in the same position in which you last left it. If this property is set to No, the form and datasheet cannot be resized, and the splitter bar is hidden.
Split Form Size Design view or Layout view Allows you to specify an exact height or width (depending on whether the form is split vertically or horizontally) for the form part of the split form. For example, type 1" to set the form to a height or width of 1 inch. Type Auto to set the dimension by other means, such as dragging the splitter bar in Layout view.
Split Form Printing Design view or Layout view Allows you to define which portion of the form is printed when you print the form. If the property is set to Form Only, only the form portion is printed. If the property is set to Datasheet Only, only the datasheet portion is printed.

Fix the form separator in place

To fix the form separator in a certain position so that it cannot be moved by the user, do the following:

  1. Switch to Design view by right-clicking the form in the Navigation Pane, and then clicking Design View.
  2. If the property sheet is not already displayed, press F4 to display it.
  3. Select Form from the drop-down list at the top of the property sheet.
  4. On the Format tab of the property sheet, set the Split Form Splitter Bar property to No.
  5. Set the Save Splitter Bar Position property to Yes.
  6. Switch to Layout view by right-clicking the form in the Navigation Pane, and then clicking Layout view.
  7. Drag the splitter bar to the position that you want (or type an exact height in the Split Form Size property box).
  8. Switch to Form view to view the results.

The separator is fixed in the position where you set it, and the splitter bar is hidden.

Add or delete a field

  1. If the Field List pane is not displayed, on the Format tab, in the Tools group, click Add Existing Fields.
  2. Locate the field that you want to add, and then drag the field to either the datasheet or the form.

If you drag a field to the datasheet, the field is also added to the form. Likewise, if you drag a field to the form, the field is also added to the datasheet.

  1. To delete a field, you must use the form portion of the split form. Click the field to select it, and then press DELETE.

The field is removed from both the form and the datasheet.

For more information about adding fields by using the Field List pane, see the article Add a field to a form or report.

Top of Page Top of Page

 
 
Applies to:
Access 2007