
Checkbox format in datagrid not showing checkboxes
Matt
I had exactly the same problem. Here is the code I wrote to get around it:
' The following converts boolean numbers to Yes/No
For x = 1 To grdClassList.Rows - 1
If IsNumeric(grdClassList.TextMatrix(x, 4)) Then
grdClassList.TextMatrix(x, 4) = IIf(grdClassList.TextMatrix(x,
4) = 0, "N", "Y")
End If
If IsNumeric(grdClassList.TextMatrix(x, 5)) Then
grdClassList.TextMatrix(x, 5) = IIf(grdClassList.TextMatrix(x,
5) = 0, "N", "Y")
End If
Next x
DoEvents
The expression "grdClassList.TextMatrix(x, 5) " just identifies a cell in
msFlexGrid. Obviously you will need to change it.
Kind Regards Mike Davies
Quote:
>I cannot seem to get the datagrid to display checkboxes.
>I have a column in the datagrid whose data field is an Access Yes/No
>field. The format (from the Property Pages) for this column is set to
>Checkbox. All I can get are ones or zeros instead of checkboxes.
>Has anyone has this problem?
>Matt Ridge
>VB6 & Access 97