• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 13. Customizing Forms > Using the Field List

Using the Field List

Another tool that’s available only in design view is the Field List. The Field List enables you to easily add new data to be displayed on a form. To see the Field List in action, you’ll build a new form based on the Plantings table, which doesn’t yet have a user interface in the database. To add one, follow these steps:

Select the Forms shortcut in the Database window.

Click the New button on the Database Window toolbar.

In the New Form dialog box, select Design View. Then select the Plantings table in the data source combo box, as shown in Figure 13.6.

Figure 13.6. Creating a new form from scratch.

Click OK to create the form and open it in design view.

Access might automatically display the Field List. If it doesn’t, either click the Field List button on the toolbar or select View, Field List. The Field List (shown in Figure 13.7) lists all the fields in the table or query on which the form is based—in this case, the Plantings table.

Figure 13.7. The Field List.

To add controls to the form, you can drag and drop items from the Field List. For example, select the DatePlanted field in the Field List; then drag and drop it onto the form. When you release the mouse button, Access creates a label and text box for this field.

Drag and drop the Notes and Future fields from the Field List to the form.

Click the Save button on the toolbar. Name the form Plantings and click OK.

Select View, Form View to see your new form.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint