printing selected pages of report (1 Viewer)

[scottpep]

I have developed a database for use on a network and have modified the tool bars. I have modified the "File" button to limit it to saving and printing-which works well in the form view, but when I go to reports the File button only shows close and exit. I have a printer icon on the tool bar already. The problem comes when I want to print only one page of the report and not the entire report. I have gone to the reports in design view and modified the tool bars, but it still does not work. Anybody have any suggestions?

 

[Robert Dunstan]

Try creating a macro that will open the print dialog box. Then in your report's toolbar customize it to add a new button that will run that macro and remove the print button. Now when you run the report and click print it should display the print dialog box allowing you to specify which printer to print to and what pages to print.

HTH
Rob