Microsoft Access 2010 Bible

Chapter 9: Presenting Data with Access Reports

365

Sizing a section

Now that you’ve created the group header, you might want to put some controls in the section,

move some controls around, or even move controls between sections. Before you start manipulat-

ing controls within a section, you should make sure the section is the proper height.

To modify the height of a section, drag the top border of the section below it. If, for example, you

have a report with a page header, Detail section, and page footer, change the height of the Detail

section by dragging the top of the Page Footer section’s border. You can make a section larger or

smaller by dragging the bottom border of the section.

For this example, change the height of the group header section to^3 ⁄ 8 inch by following these steps:

1. Move your mouse pointer to the bottom of the Category section.

The pointer changes to a horizontal line split by two vertical arrows.

2. Select the top of the Detail section (which is also the bottom of the Category Header
   section).


3. Drag the selected band lower until three dots appear in the vertical ruler (^3 ⁄ 8 ") and release
   the mouse button when you have the band positioned.

The gray line indicates where the top of the border will be when you release the mouse
button.

Moving controls between sections

You now want to move the Category control from the Detail section to the Category Header sec-

tion. You can move one or more controls between sections by simply dragging the control with

your mouse from one section to another or by cutting it from one section and pasting it to another

section:

1. Select the Category control in the Detail section and drag it up to the Category Header
   section as shown in Figure 9.35.

You should now perform the following steps to complete the report design:

2. Delete the Category label from the page header.


3. Move the ProductID control and its associated label after the Description control and its
   associated label, as shown in Figure 9.35.


4. Move the Description control and its associated label to the left so that it starts just to the
   right of the start of the Category control in the Category Header control.

By offsetting the first control in the Detail section slightly to the right of the start of the
control in the Group Header section, you show the hierarchy of the data presented in the
report. It now shows that each group of products is for the category listed in the group
header.

5. Lengthen the Description control so that it approaches the ProductID control.