Print to file using Command button 1

[compgeo]

I know how to set up a command button to print a report from a form. However, I want to "Print to File" (as if I had checked that option in the Print dialog box) instead of sending the output directly to the printer.

P.S. Send to file is NOT an option.

 

[RickSpr]

Add a new printer in the Printers folder, using the same driver as the printer you eventually want to print on. When the Printers wizard asks you what port the printer is on, choose File:. Name it anything you want. Then, any time you select that printer in an application, you'll get a dialog asking you for the file name to write to.

You may also be able to do this by manipulating the PrtDevMode and PrtMip objects, but that's quite a lot harder. Still, if you plan to distribute this to users and don't want to make them set up an additional printer, that may be your only option. I've never bothered with PrtDevMode and PrtMip, though, so you're on your own. Rick Sprague