Data grid column format

HI.....

I have a data grid to display all the data in the Access database where the user can edit these data. One of the fields in the Access database is in the Yes/No format, meaning it contains a checkbox.

My problem is...when the data from the database are displayed in the data grid the column that is suppose to have the checkbox is displayed as "0" for the unticked checkbox and "1" for the "ticked" checkbox....

What i need is for the column to display the checkbox so that the user can tick on the data they desired.....

1. can i somehow...set the format for that particular column of the
data grid so that it can display the checkbox

2.can i locked only those some columns that cannot be edited by
the user?

please help

Set the data source of the datagrid, then, right click -> retrieve fields
then right click -> properties
now you can edit every column
i think you'll need the format tab for the checkboxes

Thanks unkie....but i have a problem to do that......

There are supposed to be 4 columns in my datagrid and the checkbox is in the column no 4, but the datagrid property only have 2 columns........

the retrieve fields gets the fields that are returned by the datasource, maybe something wrong in the datasource?

is it because i'm using ADODC but did not specify the connection string in the properties but instead i'm using codes to connect with the database..........