Hi

I have bound a datagrid to an ADO recordset at runtime. The database I am using is Oracle 7.3 and I'm using the MSDAORA OLE DB provider. I am trying to display a check box in one of the columns however this doesn't seem to work because their is no BOOLEAN datatype in Oracle. The database field I am binding this column to is a NUMBER(1) populated with either 0 or -1. When I run my app no checkbox is displayed just the number 0 or 1. The strange thing is if I format this column from the Format tab on the Datagrid Property Page as Boolean rather than Checkbox it correctly displays "True" or "False"!!!

Has anyone got any suggestions????

Thanks

Neil