I've got a SQL query that returns a dataset which includes several decimal fields (precision 3, scale 2). In the itemdatabound sub, I grab one of these decimal fields e.item(i).datafield("fieldname") whose actual value is 0.99. Debug watch shows the e.item.datafield("fieldname") value as 1D. If I trace the value down using e.cells(i).text, the value correctly shows as "0.99". Anyone know why the datafield reference is rounding this value and how to stop it?
Query is very basic: select * from tablename....