Set page setup options for printing - Access

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Set page setup options for printing

Applies to: Microsoft Office Access 2003

Show For a table, query, form, or report

Open the database object (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.) in one of the following views:
Open a table or query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.) in Datasheet view (Datasheet view: A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), Print Preview (print preview: A view of a document as it will appear when you print it.), PivotTable view (PivotTable view: A view that summarizes and analyzes data in a datasheet or form. You can use different levels of detail or organize data by dragging the fields and items or by showing and hiding items in the drop-down lists for the fields.), or PivotChart view (PivotChart view: A view that shows a graphical analysis of data in a datasheet or form. You can see different levels of detail or specify the layout by dragging fields and items or by showing and hiding items in the drop-down lists for the fields.).

Open a form or report in any view.
On the File menu, click Page Setup.

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)

Show For a data access page

Open a data access page in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) or Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Internet Explorer 5.0 or later.).
On the File menu, click Page Setup.
In the Page Setup dialog box, set options for paper size, headers and footers, page orientation, and margins.

Show Set options for a module

Open the module in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
On the File menu, click Print.
In the Print dialog box, click Setup.
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.