Microsoft Access 2010 Bible

Chapter 8: Working with Data on Access Forms

309

Property Description Options

Split Form

Orientation

Determines the look of a form in

Split Form view.

Datasheet on Top: Datasheet appears at the top of

the form.

Datasheet on Bottom: Datasheet appears at the bot-

tom of the form.

Datasheet on Left: Datasheet appears to the left of

the form.

Datasheet on Right: Datasheet appears to the right of

the form.

Split Form

Datasheet

Determines whether data can be

edited in the datasheet of a Split

Form.

Allow Edits: Edits are allowed.

Read Only: Data is read-only and cannot be

changed.

Split Form

Splitter Bar

Determines whether there’s a split-

ter bar on a Split Form.

Yes/No

Save Splitter

Bar Position

Determines whether the position of

the Splitter Bar should be saved.

Yes/No

Split Form

Size

Size of the form part of the Split

Form.

N/A

Split Form

Printing

Determines which section of a Split

Form to print.

Form Only: Prints the form portion.

Datasheet Only: Prints the datasheet section.

Navigation

Caption

Overrides the word Record in the

form’s navigation buttons.

N/A

TABLE 8.4

Form Data Properties

Property Description Options

Record

Source

Specifies the source of data displayed on the

form.

N/A

Filter Used to specify a subset of records to be dis-

played when a filter is applied to a form. Can

be set in the form properties, with a macro,

or through VBA.

N/A

Filter on Load Apply filter at form/report startup. Yes/No

Order By Specifies the field(s) used to order the data in

the view.

N/A

Order By on

Load

Apply sort at form/report start-up. Yes/No

continued