decimal places with zero are being removed?

[Guest]

I am using asp and access, when I create my recordset which grabs the price
column, it is not holding the zeros after the decimal place. I have it set to
currency, and set to two decimal places.

Any Idea why these are being removed?

 

[John Vinson]

I am using asp and access, when I create my recordset which grabs the price
column, it is not holding the zeros after the decimal place. I have it set to
currency, and set to two decimal places.

Any Idea why these are being removed?

I would guess that the datatype of the field is the default Number
type, which is Long Integer. Setting the Currency datatype or the
number of decimals will not override the fact that a Long Integer *is*
an integer, a whole number with no allowance for decimals.

Change the datatype of the table field to Currency (this is the
*datatype*, i.e. use Currency instead of Number, Text, Date/Time or
the other choices; the format is a different issue).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps