Checkbox format in datagrid not showing checkboxes 
Author Message
 Checkbox format in datagrid not showing checkboxes
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



Tue, 20 Feb 2001 03:00:00 GMT
 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



Thu, 22 Feb 2001 03:00:00 GMT
 Checkbox format in datagrid not showing checkboxes
What I am really hoping to do is display an actual checkbox in the datagrid.
The format property page looks like this:

[Image]

I cannot find anything in the help file about this, but it seems like the
checkbox type would show a checkbox.

I guess "...to be set properly..." means that you can set a separate checkbox
using the values in this field.

Matt Ridge

Quote:

> 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

> >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



Sat, 24 Feb 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Checkbox format in datagrid not showing checkboxes

2. Datagrid and checkboxes

3. DataGrid with Checkboxes

4. checkbox and combobox in a datagrid?

5. DataGrid and Checkboxes

6. How do I put checkboxes in a datagrid column

7. Checkbox in ADO DataGrid

8. DataGrid & checkboxes

9. DataGrid with CheckBox in First Column

10. Checkbox in DataGrid

11. Checkbox in DataGrid...

12. CheckBox in DataGrid like Access


 
Powered by phpBB® Forum Software