Hide duplicates, but keep lines

  • Thread starter Thread starter Igor
  • Start date Start date
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.
 
Igor said:
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.
 
Back
Top