- Open a sorted report that might contain duplicate values in Design view.
- Select the text box that might contain duplicate data and click Properties
on the toolbar. - 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
- Open a grouped report that might contain duplicate values in Design view.
- Move the text box for the field you're grouping on from the group header to the detail section.
- Select the text box and click Properties
on the toolbar.
- Set the HideDuplicates property to Yes.
- Remove lines and all other controls from the group header.
- Double-click the section selector of the group header to display its property sheet.
- 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.