Make field in Access appear as checkbox

Hi there

I'm working in Visual Basic 6. I've created a database in Access 2000, that I connect to via ADO.

One of the fields in each record is a Boolean on which the user is suppose to click "Yes/No" - exactly like a checkbox.

I display the entire table from the database in a grid (for ex. MSFlexgrid etc). Is there a way to make that specific column appear like a checkbox, instead of a "0" or "-1"? Of course the value would be read as "0" or "-1" depending on whether or not the field has been ticked of. The problem is that the normal user would not know what "-1" means.

Any help would be appreciated!

Thanks!

Comments

  • : Hi there
    :
    : I'm working in Visual Basic 6. I've created a database in Access
    : 2000, that I connect to via ADO.
    :
    : One of the fields in each record is a Boolean on which the user is
    : suppose to click "Yes/No" - exactly like a checkbox.
    :
    : I display the entire table from the database in a grid (for ex.
    : MSFlexgrid etc). Is there a way to make that specific column appear
    : like a checkbox, instead of a "0" or "-1"? Of course the value would
    : be read as "0" or "-1" depending on whether or not the field has
    : been ticked of. The problem is that the normal user would not know
    : what "-1" means.
    :
    : Any help would be appreciated!
    :
    : Thanks!


    don't see any properties that can be set for the msflexgrid control.

    you may want to try using the 'microsoft ado data control [oledb]' and the 'microsoft datagrid control [oledb]'

    after setting the datasource property for the grid, right-click the grid and 'retrieve fields'
    then right click for properties, under format tab you can set a checkbox property [although i couldnt get it to work]
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion