Set the opening view of a form (one record, more than one, or datasheet)

Set the opening view of a form (one record, more than one, or datasheet)

  1. Open the form in Design view.

  2. Double-click the form selector to open the form's property sheet.

  3. In the DefaultView property box, click one of the following settings.
    Setting Description
    Single Form Displays one complete record at a time. (Form view only)
    Continuous Forms Displays as many complete records as will fit in the detail section of the form. (Form view only)
    Datasheet Displays records arranged as rows and columns. Records may scroll off the screen.

Note   If you want to disable Form view or Datasheet view, you can set the ViewsAllowed property.