The Page Setup of a Report

Introduction

Page setup consists of customizing some of the behind-the-scenes aspects of a piece of paper for printing. These include the size of a report and the orientation, etc. You have various options. After displaying a report, you can click File, click Print, and click Print. On the Print dialog box, click the Setup... button. You can then make modifications on the dialog box and click OK. If you don't want to print, click Cancel on the Print dialog box but the changes you would have made on the Page Setup dialog box would be kept.

When a report is displaying in the Design View, the Ribbon is equipped with a section named Page Setup:

When the report is displayed in Print Preview, the Ribbon is equipped with a section labeled Page Layout:

The Page Setup dialog box can be used to control the size of the printed area. To open the dialog box:

• Display the report in Print Preview. In the Page Layout section of the Ribbon, click the Page Setup button
• Display the report in Design View. On the Ribbon, click the Page Setup tab. In the Page Layout section of the Ribbon, click the Page Setup button

The Page Layout section is equipped with a button labeled Page Setup. When clicked, this button would open the Page Setup dialog box that provides the same options of the Page Layout section and more.

Practical Learning: Introducing Page Setup

1. Start Microsoft Access
2. From the resources that accompany these lessons, open the StatesStatistics2 database
3. In the Navigation Pane, double-click the Summary report

The Page Size of a Report

In most cases, when you print, you use one of the standard sizes of printed papers or envelops. To make the selection:

• Display the report in Print Preview. In the Page Layout section of the Ribbon, click the Size button
• Display the report in Design View. In the Page Setup tab of the Ribbon, click the Size button

From the list of sizes, click the one you want. Alternatively, in the Page Setup dialog box, click Page. In the Paper section, click the arrow of the Size combo box:

You can then click the desired size and click OK.

Practical Learning: Using the Page Setup

1. Right-click the tab of the report and click Design View

   

2. In the Page Size section, click the Size button:

The Layout of a Report: Portrait or Landscape

Although you can change the size of a report to almost any measures of your choice, in reality, the printing of a report is subject to external influences related to the operating system (the computer itself) and other applications must abide by those common rules. In this particular case, these have to do with the printing process followed by the device used to print. The layout of a paper specifies whether the printed result would be considered vertically or horizontally. This is referred to as the report layout or the paper orientation. There are two main options: portrait and landscape.

When a report is displayed in Design View, to check its orientation, on the Ribbon, click Page Setup. By default, a report is meant to print in portrait and you can see this if the Portrait button is clicked . To configure it for landscape, you have various options. While a report is showing in Design View, in the Page Setup section of the Ribbon, click the Landscape button . Also, when a report is displaying in Design View, click Page Setup and click the Page Setup button . Then, in the Page Setup dialog box, click Page and click the Landscape radio button:

And click OK.

If you enlarge the report too much but keep the orientation to portrait, you would receive a warning:

Practical Learning: Setting the Layout of a Report

1. In the Design View, notice the green button at the intersection of the rulers that indicates that the width of the report is too high

   

   Right-click the tab of the report and click Print Preview

   

   Notice that the text box on the right side is not displaying completely
2. On the Ribbon, in the Close Preview section, click the Close Print Preview button . You should be back in the Design View
3. On the Ribbon, click the Page Setup tab
4. In the Page Layout section, click the Landscape button
5. Close the form
6. When asked whether you want to save, click Yes
7. In the Navigation Pane, right-click the States report and click Design View

   

8. Notice that the green button has disappeared.
   Right-click the tab of the report and click Print Preview

   

9. Close the report.
   If you are asked whether you want to save, click Yes

The Margins of a Report

When a report prints, the printer keeps some sections in the left, the top, the right, and the bottom sides empty. These sections are referred to as the margins. The printer is configured to follow some default options for the margins. If you want, you can exercise some control on them. You have two options.

To use some preset options, while a report is displaying in Print Preview, in the Page Size section of the Ribbon, click Margins:

If you see the type of margins you want, click it. As another option, when the report is displaying in either the Design View or in print preview, on the Ribbon, click the Page Setup button. In the Print Options tab of the Ribbon, use the text boxes in the Margins section:

In the Print Options tab, you can change the values of the desired section(s) as you see fit.

Practical Learning: Setting the Margins of a Report

1. In the Navigation Pane, right-click the Summary report and click Print Preview
2. On the Ribbon, click Print
   
3. On the Print dialog box, click the Setup button
4. On the Page Setup dialog box, click the Print Options tab if necessary.
   Change the value of the Left text box to 1
5. Change the value of the Right text box to 1

   

6. On the Page Setup dialog box, click OK
7. On the Print dialog box, click OK to print
8. Close the report.
   If asked whether you want to save, click No

Zooming a Report

In Print Preview, we mentioned already that a report shows how the printed paper would appear. To give you a better overview, Microsoft Access may "shrink" the view. Although this may make some characters unreadable, the intent is to give you a preview of the resulting piece of paper, not necessarily a read of the contents of the report. If you still want to read the content of the report, you can enlarge its view. On the other hand, if you are not particularly interested in reading the content of the report but preview it, you can shrink the view more or enlarge it more. This is referred to as zooming the view and you can zoom in or zoom out.

Zooming is available and only relevant when previewing a report. Therefore, in order to use it, first display the report in Print Preview. To assist you with zooming, the Ribbon state for the Print Preview is equipped with a Zoom section:

By default, the Print Preview shows only one page of the report and the One Page button of the Zoom section of the Ribbon is clicked. Also, usually in that view, the characters could be difficult to read. To zoom in or zoom out of the view, click inside the report itself or click the (top side of the) Zoom button. This would change the zooming ratio. If you want a more precise zoom ratio, click the arrow button below the Zoom button. This would present a list of zooming ratios and you can select the one you desire:

As mentioned already, by default, the Print Preview presents one piece of paper. If your report contains more than one page and you want to preview a few or all of them, display more than one page. To display two pages, click the Two Pages button. To display 4, 8, or 12 pages, click the More Pages button and select the desired option.

Practical Learning: Zooming a Report

1. In the Navigation Pane, right-click the Summary report and click Print Preview
2. In the Zoom section of the Ribbon, click the arrow of the Zoom button and click Zoom 100%
3. After viewing the report, Click the Close Print Preview button

Characteristics of the Sections of a Report

The Background Color of a Section

By default, each section of a report appears white so its background would print as transparently as possible on a white piece of paper. If you want to change the background color of a section:

• Right-click the section or its bar, position the mouse on Fill/Back Color, and select a color from the window
• Click a section or its bar:
  • On the Ribbon, click Home. In the Text Formatting section, click the arrow of the Background Color button and click the desired color from the window or click More Colors to compose a color
  • On the Ribbon, click Format. In the Font section, click the arrow of the Background Color button and click a color or create one
• Double-click the section or its bar to access its Property Sheet. Then, in the Format or the All tab of the Property Sheet, click Back Color and select the desired color

If you specify the background color other than white for a section, the controls in that section would print in their own color. If you want bot the section and its controls to be printed the same, set the same background color for the controls in that section.

The Alternate Row Color of a Section

If you create a repeating section on a report, you can make the other occurrences of the section show a different color. To apply the color alternating feature, first select a section and set its background color using the Background Color button. Then:

• Right-click the section or its bar, position the mouse on Alternate Fill/Back Color and click the desired color or click More Colors to create a cusmtom color
• Click the section. On the Ribbon, click Format. In the Background section, click the arrow of the Alternate Row Color button and click a color or click More Colors to create a custom color

  

• Double-click the section. In the Format or the All tab of the Property Sheet, click Alternate Color, then click the arrow of its combo box and select the desired color or click the ellipsis button to compose a color

Here is an example of the type of result you could get:

Practical Learning: Setting the Alternate Row Color of a Section

1. In the Navigation Pane, right-click the Summary report and click Design View
2. On the report, click Detail
3. On the Ribbon, click Format
4. In the Font section, click the arrow of the Alternate row Color button and select Light Gray, Background 2 (Theme Colors: 3rd column - 1st row)
5. Right-click the title bar of the report and click Print Preview

   

6. Save and close the report

Keeping a Section on its Own Page(s)

If you create a report and design it with the default settings, the first record displays. If its values do not cover the whole page, the values of the next record start displaying on the same page but, if the next record cannot completely fit on that first page, it does not print on that page. Instead, it prints on the next page. This means that more than one record can print on the same page if and only if all those records can fit each completely on that page.

In some cases, such as if you have a report that displays a type of magazine, brochure, or catalog, you may want the first record to print on the first page, when the first record finishes, print the next record on the same page. If both records have printed on the same page and there is still enough room, the next record could start. Once the first page is full, the values left from the previous record continue on the next page. As you may suspect, these two scenarios depend on the types of values that the report is asked to print and of course, this highly depends on your intention.

The ability to keep each record on its own page is controlled by the Keep Together property of a section. To access it, display the report in Design View and double-click either the section or its bar. Keep Together is a Boolean property with a Yes and No options:

• If you set Keep Together to Yes, which is the default value, the first record displays or prints its values on the first page:
  • If there is still room on that first page, Microsoft Access calculates how much room the next record needs. If the next record can completely fit on the remaining area of the first page, then that next record is put on that first page:
     
  • If the next record is too long to fit on that first page, it would not print on it but would be sent to the next page and the remaining area of the first page would be left empty
  • If the first record itself is too long to fit on the first page, it would print on the first page and would continue printing on the next page. Then, if the next record can fit on that second page (which is usually unlikely), it would be put on that page
• If you set Keep Together to No, the first record displays on the first page, followed by the next record. If the record gets to the end of the page, it continues on the next page. This means that the records would simply continuously print one after the other:
   

A Report With Multiple Columns

All of the reports we have created so far display in one vertical list. Such a list is referred to as a column. If a report is made of a single list and the items of the list are not too wide, you can display the list in various columns. Here is an example:

To create the columns on a report, first make the list wide or narrow enough so it can fit more than once on the piece of paper. Then, display the Page Setup dialog box. In the Page Setup dialog box, set the Number of Columns text box to a value of your choice:

To display the items of the columns, you have two options. This characteristic is set in the Column Layout section:

• You can put the first item in the first column, the second item in the second column, the third item in the third column, and so on. When the list of columns is met, the items continue on the first column, followed by the subsequent columns. If you want this layout, select the Across, then Down radio buttons
• You can put the first item in the first column, followed by the second item in the first column, followed by the third item in the first column, and so on. When the first column is filled, the list continues on the second column, then the subsequent columns. If you want to use this layout, select the Down, then Across radio button.

Practical Learning: Ending the Lesson

• Close Microsoft Access

Previous	Copyright © 2002-2021, FunctionX	Next