Howdy, Stranger!

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

Categories

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

  • dokken2dokken2 Member Posts: 532
    : 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.