Format MS Access data

[enak]

I am pulling some data from an Access database. There are two columns that are of the type currency. If I query the table through Access these two fields are formatted correctly as currency.

However, when I execute the same query through a .net winform application the data is formatted as simply integers. How can I get the correct formatting?

Thanks,
enak

 

[RonRepp]

How are you accessing the recordset? ADO, I presume. Show us your connection string and some of the code.

Ron Repp

 

[PRPhx]

According to vb.net help, Currency type is no longer supported. Try using decimal type for your data instead. (And use the format command to add the $, etc.)