Setting Default Printer Properties with VBA Cocde

[EddieN1]

I have a need in Access to prompt the user for Duplex Printing and Punch holes at the top when the report is requested. Since the report goes to the Default Printer, I have found a way to dynamically modify the Default Printer when the report is started and set it back when the report is done. Now, the user wants to be able to dynamically specify Duplex printing and, if the printer supports it, Punch holes at the top of the page. Is there a way I can modify the Default Printer properties accordingly before the report is called and then set them back to what they were originally after the report is done. Thanks, Eddie

[ranman256]

check: http://support2.microsoft.com/kb/230743

[EddieN1]

Better idea is to define multiple "printers" for the same physical device. Each "printer" has a descriptive name, such as "MainDuplex", and has its own properties, i.e., duplex. When the operator gets the list of printers, he/she selects the type of printing he/she wants. I suggest you name the "printers" in a manner that your program can identify if it is a duplex printer, perhaps by including the string "Duplex" in the name, so that the reports will avoid printing the first page of a new section on the back of the last page of the previous section.