Applies To Form.
Description
Setting
The DefaultView property uses the following settings.
Setting | Description | Visual Basic |
Single Form | (Default) Displays one record at a time. | 0 |
Continuous Forms | Displays multiple records (as many as will fit in the current window), each in its own copy of the form's detail section. | 1 |
Datasheet | Displays the form fields arranged in rows and columns like a spreadsheet. | 2 |
Setting | Description | Visual Basic |
Both | (Default) Users can switch between Form view and Datasheet view. | 0 |
Form | Users can't switch to Datasheet view from Form view. | 1 |
Datasheet | Users can't switch to Form view from Datasheet view. | 2 |
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. |
DefaultView | ViewsAllowed | Description |
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. |
See Also AllowAdditions property, AllowDeletions property, AllowEdits property, AutoResize property, DataEntry property, OpenForm action.