Form.ViewsAllowed property (Access)

Use the ViewsAllowed property to specify whether users can switch between Datasheet view and Form view by choosing the Form view or Datasheet view command on the View menu, or by choosing the arrow next to the View button and choosing Form view or Datasheet view. Read/write Byte.

Syntax

expression.ViewsAllowed

expression A variable that represents a Form object.

Remarks

The ViewsAllowed property uses the following settings.

Setting	Description
0	(Default) Users can switch between Form view and Datasheet view.
1	Users can't switch to Datasheet view from Form view.
2	Users can't switch to Form view from Datasheet view.

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.

Example

The following example prints a message in the Immediate window indicating the state of how users can switch between Datasheet view and Form view for the Switchboard form.

Debug.Print "ViewsAllowed = " & Forms.Item("Switchboard").ViewsAllowed

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.