ToggleButton.HideDuplicates property (Access)
Use the HideDuplicates property to hide a control on a report when its value is the same as in the preceding record. Read/write Boolean.
Syntax
expression.HideDuplicates
expression A variable that represents a ToggleButton object.
Remarks
The HideDuplicates property applies only to controls (check box, combo box, list box, option button, option group, text box, toggle button) on a report.
The HideDuplicates property uses the following settings.
| Setting | Description |
|---|---|
| True | If the value of a control or the data it contains is the same as in the preceding record, the control is hidden. |
| False | (Default) The control is visible regardless of the value in the preceding record. |
The DefaultValue property doesn't apply to check box, option button, or toggle button controls when they are in an option group. However, it does apply to the option group itself.
You can set the HideDuplicates property only in report Design view.
Use the HideDuplicates property to create a grouped report by using only the detail section rather than a group header and the detail section.
Example
The following example returns the HideDuplicates property setting for the CategoryName text box and assigns the value to the intCurVal variable.
Dim intCurVal As Integer
intCurVal = Me!CategoryName.HideDuplicates
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for