Microsoft Access 2010 Bible

(Rick Simeone) #1

Part I: Access Building Blocks


306


TABLE 8.3

Form Format Properties


Property Description Options
Caption Text that is displayed in the form’s
title bar.

N/A

Default View Determines the initial view when
the form is opened.

Single Form: One record per page (default).
Continuous Forms: As many records per page as will
fit.
Datasheet: Row and column view.
PivotTable: Displays values horizontally or vertically;
then calculates the total of the row or column.
PivotChart: Graphical data display.
Split Form: Displays a datasheet in the upper portion
and a form in the lower portion.
Allow Form
View

Form view allowed. Yes/No

Allow
Datasheet
View

Datasheet view allowed. Yes/No

Allow
PivotTable
View

PivotTable view allowed. Yes/No

Allow
PivotChart
View

PivotChart view allowed. Yes/No

Allow Layout
View

Layout view allowed. Yes/No

Scroll Bars Determines whether any scroll bars
are displayed.

Neither: No scroll bars are displayed.
Horizontal Only: Displays only horizontal scroll bar.
Vertical Only: Displays only vertical scroll bar.
Both: Displays both horizontal and vertical scroll
bars.
Record
Selectors

Determines whether the Record
Selector is displayed.

Yes/No

Navigation
Buttons

Determines whether navigation
buttons are visible.

Yes/No

Dividing Lines Determines whether lines between
form sections are visible.

Yes/No
Free download pdf