Access.Form.AllowDatasheetView.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Form.AllowDatasheetView property (Access)	vbaac10.chm13533	vbaac10.chm13533	Access.Form.AllowDatasheetView	81796b90-94dd-cd27-3613-a2050e2bce21	03/09/2019	medium

Form.AllowDatasheetView property (Access)

Returns or sets a Boolean indicating whether the specified form may be viewed in Datasheet view. True if Datasheet view is allowed. Read/write.

Syntax

expression.AllowDatasheetView

expression A variable that represents a Form object.

Remarks

Use the AllowDatasheetView, AllowFormView, AllowPivotChartView, or AllowPivotTableView properties to control which views are allowed for a form.

Example

The following example makes Datasheet view valid for the specified form, and then opens the form in Datasheet view.

Forms(0).AllowDatasheetView = True 
DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormDS 

[!includeSupport and feedback]