Convert Forms to Reports in Microsoft Access

Use one of two methods to convert between paper and electronic reports

Businessman working on a laptop smiling.
Ezra Bailey / Getty Images

There are two primary ways to convert a Microsoft Access form to a report — one in which the data becomes static and appears as you want it to print, and one in which the data remains active and can be manipulated to organize the report as you want it to look before printing it.

Converting a Form for Printing

The process for converting a form so you can print it as a report is relatively easy.

  1. Open the database and its relevant form.
  2. Go to File Save As > Save Object As.
  3. Go to the section called Save the current database object and click Save Object As.
  4. Enter the name for the report under Save ‘Campaign List Subform’ to in the pop-up window.
  5. Change As from Form to Report.
  6. Click OK to save the form as a report.

Open the report and review it to make sure that it appears as you want it to before printing. When you are ready, click Report Under Objects under Database and select the report.           

Converting a Form to a Report That Can Be Modified

Converting a form to a report that you can modify is only slightly more complicated because you have to be aware of what view you are in when you save the report.

  1. Open the database that contains the form you want to use. 
  2. Right-click on the form you want to convert and click Design View
  3. Go File Save As Save Object As.
  4. Go to the section called Save the current database object and click Save Object As.
  5. Enter the name for the report under Save ‘Campaign List Subform’ to in the pop-up window.
  6. Change As from Form to Report.
  7. Click OK.

Now you can make adjustments to the report without starting from scratch or saving a new version of the form. If you think that the new look should become the permanent look, you can update the form to match the changes that you made to the report.