ComboBox.HideDuplicates Property
| Access Developer Reference |
You can 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 ComboBox 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. |
You can set the HideDuplicates property only in report Design view.
You can 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.
| Visual Basic for Applications |
|---|
|