Microsoft Office Tutorials and References
In Depth Information
2. In the Group, Sort, and Total pane, click to the left of the group band to select it,
click More to expand the band and display all group options, click the keep header
and first record together on one page arrow, and then click keep whole group
together on one page , and then close the Group, Sort, and Total pane.
You’ll start improving the report by moving the InvoiceItem text box to the left in
the InvoiceItem Header section and setting its font to bold.
3. Select the InvoiceItem text box in the InvoiceItem Header section and the
InvoiceDate text box in the Detail section, align the two selected controls on their
left edges, hold down the Shift key, click the InvoiceDate text box to deselect it,
release the Shift key, and then in the Font group on the Design tab, click the Bold
button . The InvoiceItem text box is displayed as bold text.
The report width is 8 inches, and Sarah will want to print the report on standard
8.5" × 11" paper, so you’ll change the page orientation to landscape, and set the
left and right margin widths to 1.5 inches each.
4. Click the Page Setup tab on the Ribbon, and in the Page Layout group on the Page
Setup tab, click the Page Setup button to open the Page Setup dialog box, click
the Page tab, click the Landscape option button, click the Print Options tab, set
the Top and Bottom margin properties to 0.7 and the Left and Right margin prop-
erties to 1.5 , and then click the OK button.
The text boxes in the Detail section are crowded together with little space
between them. Your reports shouldn’t have too much space between columns, but
reports are easier to read when the columns are separated more than they are in
the rptInvoicesByItem report. Sometimes the amount of spacing is dictated by the
users of the report, but mostly it’s the report designer’s choice to make. First, you’ll
remove the Paid label and the InvoicePaid text box from the tabular layout, resize
them, and move them to the right.
5. Select the Paid label in the Page Header section and the InvoicePaid text box (it
contains a check box) in the Detail section, right-click one of the selected controls
to open the shortcut menu, point to Layout , click Remove to remove both controls
from the tabular layout, deselect the InvoicePaid text box, right-click an edge of
the Paid label to open the shortcut menu, point to Size , click To Fit , and then
move the label to the right until its right edge is at the 8-inch mark on the
6. Click the InvoicePaid text box in the Detail section, decrease its width until it’s
slightly wider than the check box inside it, and then move it to the right until the
check box is centered under the Paid label. See Figure 7-26.
To move the remaining bound controls, you first need to remove them from the
7. Select the InvoiceAmt text box and the other three controls in that column, right-
click the InvoiceAmt text box, point to Layout on the shortcut menu, click
Remove , deselect all controls except the Invoice Amt label in the Page Header
section, right-click the Invoice Amt label, point to Size on the shortcut menu,
click To Fit , select all controls in the column, right-click one of the selected con-
trols, point to Align on the shortcut menu, click Right , and then move the selected
controls to the right. See Figure 7-26.
8. Refer to Figure 7-26 and repeat Step 7 for the ContractType , City , and Customer
bound controls, in that order, but do not align the bound controls on their right
edges. See Figure 7-26.
You usually determine page
setup properties when you
design a report or, as in
the case of this report,
after you’ve placed the
controls in the Detail
You can resize labels and
controls added with the
Label tool to fit, but you
can’t resize text boxes