Hide duplicates, but keep lines

[Igor]

Hello,

Is it possible to hide duplicates but keep all dividing lines? (I need this
so that it looks like a table).

Thanks in nadvance for your responses.

 

[Marshall Barton]

Is it possible to hide duplicates but keep all dividing lines? (I need this
so that it looks like a table).

If the "lines" are the controls' border, then, no, it's not
possible.

I think the easiest way to get that effect is to make the
text boxes that might be hidden BorderStyle Transparent and
use the section's Print event with VBA code to draw the
lines around:

With Me.textbox1
Me.Line (.Left,.Top)-Step(.Width,.Height),,B
End With
repeat for each text box.

 

[Igorin]

Perfect!!!

Thank you very much, Marshall!!!