*** Resolved ***Datagrid display settings

[that_jay_guy]

Hopefully this is an easy question for somebody.

I have created a Database interface (I'm using VB6), with an ADODC connection to an Access Database and am viewing the information using a Datagrid. The idea is that one of the fields be a check box so the user can identify which fields are to be deleted.

The database is structured so that there is a "Deleted" field and is set to be displayed as Checkbox in Access. The Datagrid is also set to Checkbox but it will not honor/display as a Checkbox.

The notes on the Datagrid Property Page say "This format allows a checkbox to be set properly when bound to a boolean column.". The column that it is bound to in Access has a data type of "Yes/No" (There is no actual boolean option).

Any suggestions?

Thanks in advance for any help.

JD

[ralph]

MS Lied!!!

Flexgrids have a workaround implementing a cellpicture property to toggle checked/unchecked bitmaps into the cell upon clicking.

As for datagrids, a possible alternative is to implement a combo box (a combination of a column Buton property and invisible listbox) yes/no selection effect.