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 checkbox not showing changed state.

3. checkbox in datagrid not visible

4. Checkbox in Excel to control checkbox in Word ???

5. Link checkbox whitin Excel to a checkbox in Word,

6. Link checkbox whitin Excel to a checkbox in Word,

7. UserForm Checkbox link to Checkbox in document

8. Control Checkbox -vs- Form Checkbox

9. checkbox collection vs single checkbox

10. checkbox arrays vs single checkboxes

11. Sending a checkbox response from OL form to Word checkbox

12. checkbox collection vs single checkbox

 

 
Powered by phpBB® Forum Software