To hide duplicate values in a report, which property should be set to 'Yes'?

Setting the "Hide Duplicates" property to 'Yes' is the correct approach to eliminate duplicate values in a report. When this property is enabled, Access scans through the data being displayed in the report and suppresses the subsequent occurrences of duplicate entries, ensuring that only the first instance of each value appears. This feature enhances the clarity and legibility of reports by preventing redundancy, making it easier for users to analyze the data.

The other properties listed, such as Data Format, Visibility, and Record Source, do not specifically target the suppression of duplicate values. Data Format pertains to how the data is visually presented (e.g., currency, date formats), Visibility determines whether a report control is visible or hidden without affecting data duplication, and Record Source defines where the data for the report is drawn from. None of these properties influence the way duplicate values are handled within the report like the "Hide Duplicates" property does.