Is there a way to change the datatype of a column in a data grid whihc is linked to an adodc control? The datatyoes are all correct in the db but currency values are being displayed as integer values by the datagrid.

If you are using Access, just select the control, open the property dialog box, and change the format to currency.

mmcdonal

I have all the datatypes set correctly in the access database. I alos have an adodc control on the form. the datagrids datasource is set to the adodc control, but when the datagrid is populated the currency values are displayed incorrectly.

Any ideas?

Thanks.