Set page setup options for printing

For a table, query, form, or report

1. Open the database object in one of the following views:

   Open a table or query in Datasheet view, Print Preview, PivotTable view, or PivotChart view.

   Open a form or report in any view.

2. On the File menu, click Page Setup.
3. Click the following tabs and set the options you want:

   Tab	Options
   Margins	Whether to print data only (for forms and reports), or to print headings (for tables or queries)
   Page	Orientation, paper size, and printer
   Columns	Number, size, and layout of columns (for forms and reports)

For a data access page

1. Open a data access page in Design view or Page view.
2. On the File menu, click Page Setup.
3. In the Page Setup dialog box, set options for paper size, headers and footers, page orientation, and margins.

Set options for a module

1. Open the module in Design view.
2. On the File menu, click Print.
3. In the Print dialog box, click Setup.
4. Set the options you want.

Notes

• Page setup options aren't available for macros.

• Microsoft Access stores the settings for page setup options with a form or report, so you set these options only once for each form or report. For tables, queries, data access pages, and modules, you must set page setup options every time you print.