Flexgrid - colspan?

I am looping through a recordset populating a flexgrid with 7 columns.

Every now and then I want to write a heading that spans the 7 columns.
Is this possible?

I have tried saying MSFlexGrid1.cols = 0 ... as I write the heading and MSFlexGrid1.cols = 7 after I have written the heading but it does not work.

Thanks for any input.

There is a "How to use MsFlexgrid" link in my signature so take a look.

@RB: I don't think that thread has anything about merging cells

@webskater: try something like this:

VB Code:

Private Sub Command1_Click()
    With MSFlexGrid1
        .Redraw = False
        .FillStyle = flexFillRepeat
        .MergeCells = flexMergeFree
        .MergeRow(0) = True
        .Row = 0
        .Col = 1
        .ColSel = 7
        .CellAlignment = flexAlignCenterCenter
        .Text = "Header"
        .FillStyle = flexFillSingle
        .Redraw = True
    End With
End Sub

Quote:

---

Originally Posted by bushmobile

@RB: I don't think that thread has anything about merging cells...

---

It doesn't? Hmmm... can you please add some sample then? Thanks, Bush.

Thanks for your replies - I'll give it a go.