Select Printer

[Robert_(Guest)]

I am using the following code in an Microsoft Access 2007 program.____ WDir = "c: rdebtorsFor130os.rsw"__ Report1.ReportName = WDir__ Report1.Destination = 1__ Report1.Action = 1______My question is....____I want to get this report to print to a non default printer.____1. Can i just select the printer i need when designing the report and save it.. ??? will it allways remember this printer ???____2. How do i get the windows printer selection dialog box to pop up, so the user can select the required printer at runtime...________Regards Robert__

[Robert_(Guest)]

Kathleen______Thanks very much, much appreciated______Regards Robert

[kfleming]

You use the Printer property to set the printer that will be used in the report.__Here is the information from the Help file.____Printer______Specifies the name of the printer to which the report is to be printed.____Usage____ControlName.Printer [= PrinterName$]____Example____RSReport1.Printer = "HP LaserJet 4/4M"____« Prints the report to a printer called "HP LaserJet 4/4M." »____Comments____This property is optional. Enter a value to override the printer saved with the report. This property can have one of two values:____The name of an available Windows printer. Available Windows printers are listed in the Report Designer Print dialog (accessed by selecting File ? Print in Report Designer). The value is case insensitive (that is, you can enter it in upper, lower, or mixed case).____The question mark (?) value, to allow the user to select a printer at report execution. When the Printer property contains a question mark, the Print dialog shown below will display.__The word Default to force the Report Viewer to use the current default Windows printer. Use this setting only if you are sure that the default printer is compatible with the layout of your report(s).______Kathleen__R&R Support