msflexgrid Text Colour Help

[cwaldick]

I need help on two things:

First How do I change the colour, style of the font for a whole row in the msflexgrid control in code
And Only That Row

secondly: How do I Hide A column In the Flex Grid Control

Help Would be much Appreciated


HELP!!!!!!!!!!!!!!!!!!!

[dadames]

try...

.ColWidth(idx)

where idx is the index of the column to be hidden

[sarun]

Check out the CellForColor/CellFontName properties of the mshflexgrid control.

this changes color/font for a single cell. Not sure if there is a similar one for Row. If not may be you need to loop though all cells in the row???

[dadames]

Sorry, I forgot the assignment of zero

.ColWidth(idx) = 0

where idx is the index of the column to be hidden

[ashky]

'Sub routine to set the color and bold property

Sub ChangeBackColour(ByVal lngColour As Long, ByVal blnFontBold As Boolean)
Dim i As Integer

For i = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.Col = i
MSFlexGrid1.CellForeColor = lngColour
MSFlexGrid1.CellFontBold = blnFontBold
Next i
End Sub


In the form load event just call the funtion . For example:

For intRow = 0 To MSFlexGrid1.Rows - 1
If Val(MSFlexGrid1.TextMatrix(intRow, intCol)) = 1 Then
MSFlexGrid1.Row = intRow
ChangeBackColour vbRed, False
End If
Next


hope this helps ....,


ashky

[cwaldick]

Thank You Very Much However I gave Up A while ago and bought myself the VSFlex grid it is amazing what other nice features comes with it