ListView Query

[cdchapman]

Hi,

Not sure if this is possible, but is there any way of inserting a horizontal line between rows of data in a Listview control on a userform?

At present the listview displays data as below:

Title 1 Title 2 Title 3
Data1 Data 2 Data 3
...
...
TOTALS Total 1 Total 2

The totals line is displayed using a different font colour from the rest of the data which is fine, but it would look better if there was a horizontal line separating the totals from the rest of the data, something like:

Title 1 Title 2 Title 3
Data1 Data 2 Data 3
...
...
________________________
TOTALS Total 1 Total 2

I've tried adding the horizontal line using the "_" character in a ListItem, but this has breaks at each column - does anyone know if it is possible to make the line continuous (in effect merging the columns just for that line)?

 

[Flammy]

Maybe add the character to each element?

x = "Title 1" & "|"

then add x to the listview? add spaces and such as needed.

 

[cdchapman]

Thanks for the suggestion Flammy, but this will add a vertical line separating the columns won't it? Also my listview uses a non-proportional font, so I don't think the "|" characters will line up correctly to form a line anyway even with spaces added.

I ideally need an unbroken horizontal line separating the totals from the rest of the data, not a vertical line.