You can use the PrintOut macro action in Access desktop databases to print the active object in the open database. You can print datasheets, reports, forms, data access pages, and modules.
Note: This macro action will not be allowed if the database is not trusted. For more information about enabling macros.
Setting
The PrintOut macro action has the following arguments.
|
Action argument |
Description |
|
Print Range |
The range to print. Click All (the user can print all of the object), Selection (the user can print the part of the object that's selected), or Pages (the user can specify a range of pages in the Page From and Page To arguments) in the Print Range box in the Action Arguments section of the Macro Builder pane. The default is All. |
|
Page From |
The first page to print. Printing starts at the top of this page. This argument is required if you select Pages in the Print Range box. |
|
Page To |
The last page to print. Printing stops at the bottom of this page. This argument is required if you select Pages in the Print Range box. |
|
Print Quality |
The print quality. Click High, Medium, Low, or Draft. The lower the quality, the faster the object prints. The default is High. |
|
Copies |
The number of copies to print. The default is 1. |
|
Collate Copies |
Click Yes (collate the printed copies) or No (do not collate copies). The object may print faster if this argument is set to No. The default is Yes. |
Remarks
This action is similar to selecting an object, and then clicking File > Print. With this action, however, no Print dialog box appears.
TIP
If you have particular print settings you use frequently, create a macro containing a PrintOut action with these settings in its arguments.
The arguments for this action correspond to options in the Print dialog box. However, unlike the FindRecord action and Find and Replace dialog box, the argument settings aren't shared with the Print dialog box options.
To run the PrintOut action in a Visual Basic for Applications (VBA) module, use the PrintOut method of the DoCmd object.
