[RESOLVED] MsFlexGrid Problem

[LukeD4567]

Is it a known issue that after clearing a MSFlexGrid control using the .Clear method, formatting does not display properly?

I populate the grid using the following method:

   msFlxGrd.AddItem (sRecord & vbTab & CStr(sValue))
   
   If bHeader Then
        'This is a header, change the background colour.
        msFlxGrd.Redraw = False
        msFlxGrd.MergeCells = flexMergeRestrictRows
        
        msFlxGrd.row = msFlxGrd.Rows - 1
        msFlxGrd.MergeRow(msFlxGrd.Rows - 1) = True
        msFlxGrd.CellBackColor = &HDBD8D7
        msFlxGrd.CellFontBold = True
        msFlxGrd.Redraw = True
      ' msFlxGrd.TopRow = msFlxGrd.Rows - 1
    end if

Once I call the clear method, and call the same code as above, it inserts the data fine, but the formatting does not take effect, (cellfontbold, cellbackcolor).
Any ideas?

Here is my clear method:

   msFlxGrd.Redraw = False
   msFlxGrd.clear
   msFlxGrd.Rows = 0
   msFlxGrd.Redraw = True
   msFlxGrd.Refresh

Ive been playing around with the refresh/redraw, but it makes not difference.

Thanks,
Luke

[gavio]

Try:

msFlxGrd.Col = msFlxGrd.FixedCols

... before adding item.

[LukeD4567]

That seems to have solved it, thank you very much sir.