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.

ID Card Copy: Make a copy of both sides of an ID card from the scanner glass. Touch Back to return to the Copy screen. Touch Start Black or Start Color to start the copy job. The printer prints the copy job. Last option under settings is to control the Lighter or Darker copy. Let me know if this helped. Add visual security to ID cards at no extra cost. Exclusive to all Magicard printers, HoloKote is a patented technology that can print a secure watermark on every card. The Pronto is supplied with four predefined watermarks that can be easily selected from the printer driver.

Printing data directly from tables or queries works when you want to print just a simple list. 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. 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.

For more information about creating a report see Introduction to reports in Access.

In this article

Select page setup options

After you create your report you can set options for the print layout in the Page Setup dialog box. 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. To set the print page options, complete the following steps:

1. In the Navigation Pane, right-click the report and then click Print Preview.
2. On the Print Preview tab, in the Page Layout group, click Page Setup and set the margins, orientation and column settings that you want.
   Print Options tab settings

Setting	Description
Margins (inches)	Increase or decrease the default margins as required, and see the changes displayed in the Sample page.
Print Data Only	Select this option when you do not want to print the layout features in the report such as grids.
Split Form	This option is not available for a report.

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.

Page tab settings

Setting	Description
Orientation	Select either the Portrait or Landscape orientation. If you want to see how the report appears, instead of setting the orientation here set it from the Page Preview tab. On the Print Preview tab, in the Page Layout group, click Portrait or Landscape.
Paper	Select the paper size and source.
Printer for Customer Addr...	If you select Use Specific Printer you can set several other printer and document format options.

Columns tab settings

Note: These options are also available on the Print Preview tab, in the Page Layout group, under Columns.

Setting	Description
Grid Settings	Select the number of columns and row spacing. If the setting is for a single column, the Column Spacing and Column Layout options won't be available.
Same as Detail	Select to print the column in the same size as you set in the report. To adjust the column width and height, clear the selection and type new values.
Column Size	Select the width and height of the columns.
Column Layout	Select the direction in which you want the columns printed. This option is available only when you have more than one column.

Select printer settings

After 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.