How to Create a Split Form: MS Access

How to Create Split Form

A split form is a new feature that introduced in MS 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. You can select a field in a record on a datasheet view then a form view will change to that record. You can also add, edit, or delete data from either part.

first look

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.

How to create a new split form by using the Split Form tool

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 on More Forms and click on Split Form.
The Access will auto create the form and displays it in Layout view. In Layout view, you can make design changes to the form while it is displaying data.

split form

You can open form in a Form Design View as shown on the picture below. You can expand the Form Header to have more space for a form header.

split form design

After you expand a Form Header, you can also resize the Form Header or the datasheet view. If you move a splitter bar up to the top of form it will cover the area of form detail section. Sometime we need only a datasheet form with a form header.

resize split form

We can also add some buttons and text boxes under the form header section to perform function and display a result on the datasheet form. It is similar to a datasheet form, but datasheet form does not have a form header.

add button

How to set form separator in a certain position so that it cannot be moved by the user

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. On the Format tab of the property sheet
– set the Split Form Splitter Bar property to No
– Set the Save Splitter Bar Position property to Yes
– Set the Border Style to None
– Set the Scroll Bars to Neither
4. Switch to Layout view by right-clicking the form in the Navigation Pane, and then clicking Layout view.
– Drag the Splitter Bar to the position that you want
– or type an exact height in the Split Form Size property box (1.2” on example)

set property

5. Switch to Form View to view the results.

split form done

Related Video:

Related posts