Print microsoft access report specific printer

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. Select page setup options. Select printer settings. Preview before printing. 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:. In the Navigation Pane, right-click the report and then click Print Preview. On the Print Preview tab, in the Page Layout group, click Page Setup and set the margins, orientation and column settings that you want. Increase or decrease the default margins as required, and see the changes displayed in the Sample page.

Select this option when you do not want to print the layout features in the report such as grids. 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.

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. If you select Use Specific Printer you can set several other printer and document format options.

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. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Setting up a report to print to specific printer Ask Question. Asked 11 years, 4 months ago. Active 8 years, 4 months ago. Viewed 12k times.

Improve this question. Gert Grenander I know it's one of those "is it plugged in? You likely are doing so, and are hitting the bug cited by Remou, but if you're not, the printer change will never be saved. Add a comment. In Access or a later version, click the command button in the design view, and then click Property Sheet in the Tools group on the Design tab.

Click the Event tab, click the On Click property, click the down arrow, and then click [Event Procedure]. To print rptMyReport to a specific printer, open frmForm1 in Form view, and then click the appropriate button. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No.

You'll find an example in Labelprinter. If you have difficulty opening the link copy its text NB, not the link location and paste it into your browser's address bar. This simple little demo file illustrates how ad hoc labels can be printed, starting at a selected position on a partly used sheet of labels. The labels are merely a report, and the demo includes a means of selecting a printer from a list box which lists all installed printers.

Ken Sheridan, Stafford, England. For example in pseudo code : DoCmd. Close acReport, "ReportName" untested Hope that helps Hi Dianna, If that doesn't work, you could also try changing the default printer by using a Printer object.