Set page setup options for printing

Microsoft Office Access 2003

previous page next page
  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)

ShowFor 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.

ShowSet 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.

previous page start next page