How To Display a Field List in the Report Design Window

The Microsoft Access application allows you to manage databases and construct data reports. When you create a database, you can access the Report Design window by choosing "Design" view. You will then be able to view the design of tables, forms, macros, reports and queries. You can also display the field list to add or remove fields from a report you have created. Once the field list is displayed, you hide or show specific fields within the list.

Things You'll Need

• Microsoft Access

Instructions

1. Open the Microsoft Access file on your computer that you want to work with and display the field list.

2. Click on the "Design View" button from the status bar located at the bottom of the application.

3. Click on the "Field List" button from the top Design toolbar for Access 2003 or click on the "Add Existing Fields" button from the Design tab for Access 2007.

4. Click on the plus sign or minus sign boxes in the field list to hide or show any additional fields you have.

5. Right-click on your report with the field list displayed and then click on the "Save" option.

References

• Microsoft Office: Show or Hide the Field List
• Function X: Introduction to Controls Design
• Georgia Southwestern State University: Access 2007 Getting Started