MSHFlexgrid Multibanded

[NJLDoc]

I have a shaped recordset set to the recordset property of an MSHFlexgrid and can effectivley navigate and format data in any cell. I cannot however colour a cell back colour if the cell is part of the appended (hierarchial) recordset. Cells that are part of the parent recordset are easily coloured by setting the current row and column and then .CellBackColor = vbRed. Any ideas?

 

[NJLDoc]

Figured it out. Must of had a brain freeze as the col and row values must be set first just like the main part of the grid data.