

To print just one page of your report, set both the From and To fields to the same page number. For example, to print just page 5 of a report, type 5 in both the From and the To boxes. To print only selected pages of the report, select Pages and set the range. If you haven't set the orientation and paper size, click the Properties button. Select the printer where you want to have the report printed. The following table describes the results you can expect from specific printer settings: Select your print options, and then click OK to print your report. On the Print Preview tab, in the Print group, click Print. In the Navigation Pane, right-click the report that you want to print, and click Print Preview. This option is available only when you have more than one column.Īfter you complete the page setup settings for your report, you can select specific printer options to control the print layout or the pages you want printed and the number of copies. Select the direction in which you want the columns printed. Select the width and height of the columns. To adjust the column width and height, clear the selection and type new values. Select to print the column in the same size as you set in the report. If the setting is for a single column, the Column Spacing and Column Layout options won't be available. Select the number of columns and row spacing. Note: These options are also available on the Print Preview tab, in the Page Layout group, under Columns. If you select Use Specific Printer you can set several other printer and document format options.

On the Print Preview tab, in the Page Layout group, click Portrait or Landscape. If you want to see how the report appears, instead of setting the orientation here set it from the Page Preview tab. Select either the Portrait or Landscape orientation. To customize the margins on your report, on the Print Preview tab, in the Page Size group, click Margins and select a suitable option and a preview of the report with the changed margin settings is displayed. This option is not available for a report. Select this option when you do not want to print the layout features in the report such as grids. Increase or decrease the default margins as required, and see the changes displayed in the Sample page.


On the Print Preview tab, in the Page Layout group, click Page Setup and set the margins, orientation and column settings that you want. In the Navigation Pane, right-click the report and then click Print Preview. To set the print page options, complete the following steps: These options help you fine tune the format with options for margin settings, use of gridlines and columns, or print only the data from the report without the formatting. In this articleĪfter you create your report you can set options for the print layout in the Page Setup dialog box. By printing data from a report, you can compare, summarize, and total large sets of data, and then present that information in an attractive layout.įor more information about creating a report see Introduction to reports in Access. Forms are better suited for viewing or printing data for a single record or a related set of records, and not for printing larger sets of data or data summaries. Printing data directly from tables or queries works when you want to print just a simple list. While you can print data from a table, query, form or report in your Microsoft Access database, you can set print options for reports that will produce an eye-catching and more readable printed copy of your data. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.
