Show All

Print the group header on the same line as the first detail record

A report that uses block layout prints the group header on the same line as the first detail record. You can create a report that uses a block layout in one of the following ways:

• For a new report, use the Report Wizard and choose Block as the layout.
• For an existing report, hide duplicate data.

  How?

  Hide duplicate data on a report with only sorted records

  1. Open a sorted report that might contain duplicate values in Design view.
  2. Select the text box that might contain duplicate data and click Properties on the toolbar.
  3. Set the HideDuplicates property to Yes.

     In a text box for which HideDuplicates is set to Yes, Microsoft Access prints a value in the first record in which that value occurs and, if records with the duplicate value continue onto another page, at the top of a new page.

  Hide duplicate data on a report with grouped records

  1. Open a grouped report that might contain duplicate values in Design view.
  2. Move the text box for the field you're grouping on from the group header to the detail section.
  3. Select the text box and click Properties on the toolbar.
  4. Set the HideDuplicates property to Yes.
  5. Remove lines and all other controls from the group header.
  6. Double-click the section selector of the group header to display its property sheet.
  7. Set the Height property of the group header to 0.

     The group name will appear only at the beginning of a new group or at the top of a new page if the group continues for more than one page.