MS-Access / Getting Started

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.

[Previous] [Contents] [Next]