I have a yes/no data on the database (ex. access db) which is -1 or 0 and then I would like to retrieve those record back to msflexgrid checkbox as wingding.
How will I do this if this involves multiple records?
Printable View
I have a yes/no data on the database (ex. access db) which is -1 or 0 and then I would like to retrieve those record back to msflexgrid checkbox as wingding.
How will I do this if this involves multiple records?
When you load your grid you can assign font to individual cells using CellFontName property.
The trick here is to set column index before setting row. Here is a quick sample:
Code:Private Sub Command1_Click()
Dim i As Integer
With MSFlexGrid1
.Col = 3
For i = 1 To .Rows - 1
.Row = i
.CellFontName = "Wingdings 2"
.TextMatrix(i, .Col) = Chr(80) 'or 82
Next i
End
thanks Rhinobull, I will try to figure out with your code to come up with what I need.