Table of contents
TOC
Collapse the table of content
Expand the table of content

Form.DefaultView Property (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

You can use the DefaultView property to specify the opening view of a form. Read/write Byte.

Syntax

expression. DefaultView

expression A variable that represents a Form object.

Remarks

The DefaultView property uses the following settings.

SettingVisual BasicDescription
Single Form0(Default) Displays one record at a time.
Continuous Forms1Displays multiple records (as many as will fit in the current window), each in its own copy of the form's detail section.
Datasheet2Displays the form fields arranged in rows and columns like a spreadsheet.
PivotTable3Displays the form as a PivotTable.
PivotChart4Displays the form as a PivotChart.
Split Form5Displayes a split view of a Single Form and a datasheet containing the form's records.

The views displayed in the View button list depend on the setting of the ViewsAllowed property. For example, if the ViewsAllowed property is set to Datasheet, Form View is disabled in the View button list and on the View menu.

The combination of these properties creates the following conditions.

DefaultViewViewsAllowedDescription
Single, Continuous Forms, or DatasheetBothUsers can switch between Form view and Datasheet view.
Single or Continuous FormsFormUsers can't switch from Form view to Datasheet view.
Single or Continuous FormsDatasheetUsers can switch from Form view to Datasheet view but not back again.
DatasheetFormUsers can switch from Datasheet view to Form view but not back again.
DatasheetDatasheetUsers can't switch from Datasheet view to Form view.

See also

Concepts

Form Object

© 2017 Microsoft