Microsoft Access Form Design Default View

Ask us a question on-line
or get our email address on scr.im

Access Programmers has a mission to help people improve productivity through the effective use of technology.

 

 

Microsoft Certified Partner

  

Default View

If you click on the Default View field, a drop down arrow will appear to the right of the field. If you click on the arrow, three values will appear for your selection. You can select from Single Form, Continuous Forms, or Datasheet.

select your default view

Single Form

The Single Form option allows a user to view only one record at a time. The form below displays one record from the Suppliers Table. At the bottom of the form, you will see what is called a navigation bar or record selectors. These arrows allow you to navigate from one record to another. This navigation bar also alerts you that there are 29 records that you can navigate to in this form.

single form default view

Continuous Forms

The Continuous Forms option allows you to view multiple records in the form at one time. The scroll bar on the right allows you to scroll up and down through all of the records. At the bottom of the form in the navigation bar, you are still provided the record selectors to navigate through the records. In this example, there are 77 records that are available for viewing using this form.

continuous form default view

Datasheet

The Datasheet option is rather unique since the data appears as if you are looking at the actual table. With this option, you can resize the columns or even reorder the columns by highlighting and dragging the column to another location.

As you can see, you are still provided the scroll bar on the right to navigate, as well as the navigation bar and record selectors at the bottom of the form.

datasheet default view

Auto Center >