Set page setup options 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 or Print Preview.
     
     
   • Open a form or report in any view (or from the Database window).

   Note   Page setup options aren't available for macros or modules.

2. On the File menu, click Page Setup.
   
   
3. Click the following tabs for the options you want to set:
   • Margins. To set margins and whether to print data only (for forms and reports) or to print headings (for tables or queries).
     
     
   • Page. To set orientation, paper size, and printer.
     
     
   • Columns. To set number, size, and layout of columns (for forms and reports).
4. Click OK.

   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, and modules, you must set page setup options every time you print.