Creating Forms  «Prev 

Ways to create Access AutoForm

There are several other ways to create an AutoForm. Most notably, anywhere you see the New Object button (for instance, the datasheet view of both tables and queries) you can use it to create an AutoForm.
However, there are actually three types of AutoForms, and you should know about all of them. Remember that the definition of an AutoForm is a form created from the fields in one table. However, the format of the AutoForm can vary. Three formats are available:
  1. Columnar: This format is what you create with the AutoForm button. The form is a two-column format with the list of field names on the left and the field contents on the right. Only one record is displayed at a time.
  2. Tabular: This format creates a glorified datasheet. It’s a little more attractive, but it displays field names in a row along the top, and multiple records in rows underneath.
  3. Datasheet: This type of form looks like a datasheet. The form you created in the Simulation showed the fields from the Hours table in this style.

To choose the style of your AutoForm, follow these steps:
  1. Display the Forms view of the database window.
  2. Click the New button on the database window toolbar.

Access Formats
  1. Select the type of AutoForm you would like to create from the three listed.
  2. Choose the table or query to base the form on.
  3. Click OK.