So far, this discussion of printing in Access has assumed that you want to print to your default printer. You can also print a report or other database object to a different printer and control the range of pages that are printed or the actual records that are printed. These settings are controlled in the Print dialog box.
From the Print Preview mode or with a particular object open in the Access window, select File, Print. The Print dialog box appears (see Figure 20.4).
Figure 20.4. The Print dialog box enables you to select a different printer or specify a print range.
To select a different printer (one other than the default), click the Name drop-down list and select a printer by name . If you want to select a range of pages to print (such as a range of pages in a report), click the Pages option button and then type the page range into the page boxes.
In the case of tables and queries, you can also print selected records. Before you open the Print dialog box, select the records in the table or query. Then, when you open the Print dialog box, click the Selected Record(s) option button.
When you have finished changing the default printer or specifying a page range or the printing of select records, you are ready to print the object. Click the OK button. This closes the Print dialog box and sends the object to the printer.