Printer Settings - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Printer Settings

Leon Heick

5 years ago

I put a print button on a report to print the report using VBA Code
Private Sub btnPrintDoc_Click()
DoCmd.PrintOut , , , , 1
End Sub.
The report prints on both sides of the paper. How do I force the printer using VBA to print single sided.
Than you.

	Adam Schwanz @Reply 5 years ago
It prints to your default printer settings. Do you need that to be set on duplex by default? I know there are some duplex commands but I'm not sure exactly how they work. You may need to make a loop to print out the pages in the report individually rather than all at once so they only take up one page.

	Richard Rost @Reply 5 years ago
Yeah, I'm pretty sure Access can't modify printer settings by itself. It's going to use your printer settings saved IN THAT REPORT the last time you manually printed it. You can probably change the settings with some Windows API calls, but I've never tried that before.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View