Copying Forms to Reports
If you have a form that you want to print, you can certainly print it as is, but you have a lot more control over the format if you turn the form into a report first. You can then change the design for the report to print nicely without changing the format of the original form.
To save a form as a report, select the form in the Navigation Pane, click the Office Button, and choose Save As from the menu. When you see the Save As dialog box, type a name for the new report and set the drop-down list to the Report option. Access creates a new report based on the design of the form.
Most forms have gray backgrounds. After saving a form as a report, be sure to change the background of your new report to white before printing the report. Otherwise, you waste a lot of ink (or toner). Just right-click the background of each section, choose the Fill/Back Color option from the shortcut menu that appears, and choose the white box in the palette of colors.
In this tutorial:
- Creating and Editing Reports
- What are Forms and Reports
- Creating Reports Automatically
- Running the Report Wizard
- Creating Simple Reports
- Editing Reports in Design View
- Adding page headers, footers, and numbers
- Adding sections that group your records
- Sorting the records in your report
- Calculating group subtotals and report totals
- Formatting Tips and Tricks
- Copying Forms to Reports
- Adding and Formatting Subreports
- Displaying Empty or Long Fields
- Creating Mailing Labels