Hide duplicates, but keep lines

I

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.
 
M

Marshall Barton

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


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.
 
Top