Disable a view for a form

  1. Open the form in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  2. Double-click the form selector (form selector: The box where the rulers meet, in the upper-left corner of a form in Design view. Use the box to perform form-level operations, such as selecting the form.) to open the form's property sheet.
  3. Do one or more of the following:
    • To disable Form view, set the AllowFormView property to No.
    • To disable Datasheet view, set the AllowDatasheetView property to No.
    • To disable PivotTable view, set the AllowPivotTableView property to No.
    • To disable PivotChart view, set the AllowPivotChartView property to No.

 Notes 

  • The views displayed in the View button list and on the View menu depend on the setting of these properties.
  • You can use this property with the DefaultView property to control how users view a form.
  • These properties are not available in Microsoft Access 2000 or earlier. To disable a view in a previous version of Access, set the ViewsAllowed property of a form.
 
 
Applies to:
Access 2003