Convert an Access form to a report before printing

You create the necessary tables and forms for your database, but when you print all your form’s records, Access prints one page for each record. You can create a report; this will save you paper, but it will also take some time to create. A quicker alternative is to simply convert your form to a report and then print the report. Follow these steps to convert an Access 2003/2002 form to a report for printing:

1. Open the database containing the form.
2. Click Forms Under Objects in the Database window.
3. Right-click the form you want to convert to a report.
4. Click Save As.
5. Click in the Save “Form_Name” To text box and enter a name for your report.
6. Click the drop-down arrow in the As text box and select Report from the list, then click OK.

To print the report, click Reports Under Objects in the Database window and then select the report.

To convert an Access 2007 form to a report, follow these steps:

1. Open the database containing the form.
2. Click the name of the form in the Navigation pane.
3. Click the Microsoft Office button.
4. Point to Save As and then click Save Object As.
5. Click in the Save “Form_Name” To text box and enter a name for your report.
6. Click the drop-down arrow in the As text box and select Report from the list, then click OK.

To print the report, click Reports in the Navigation pane and then select the report.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.