DefaultView Property

Microsoft Access Visual Basic

Show All Show All

DefaultView Property

You can use the DefaultView property to specify the opening view of a form.

Remarks

The DefaultView property uses the following settings.

Setting Visual Basic Description
Single Form 0 (Default) Displays one record at a time.
Continuous Forms 1 Displays multiple records (as many as will fit in the current window), each in its own copy of the form's detail section.
Datasheet 2 Displays the form fields arranged in rows and columns like a spreadsheet.
PivotTable3Displays the form as a PivotTable.
PivotChart4Displays the form as a PivotChart.

The views displayed in the View button list and on the View menu 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.

DefaultView ViewsAllowed Description
Single, Continuous Forms, or Datasheet Both Users can switch between Form view and Datasheet view.
Single or Continuous Forms Form Users can't switch from Form view to Datasheet view.
Single or Continuous Forms Datasheet Users can switch from Form view to Datasheet view but not back again.
Datasheet Form Users can switch from Datasheet view to Form view but not back again.
Datasheet Datasheet Users can't switch from Datasheet view to Form view.