Decimal place MIA

I have a field which has a decimal place in the query results in report
designer, but on a table in the report it doesn't show the decimal place. So
a 10.5 shows as just 10. I already use the cint function to convert it from
string to int, but that doesn't help. This was working, and I'm not sure if
it's related it but I think after I upgraded to RS SP2 this started happening.CInt() will convert from string to integer and ignore all decimal places.
Use CDbl() instead - it will convert from string to double. Also, do you use
a format code property on the textbox which shows the field's value?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Patten" <ChrisPatten@.discussions.microsoft.com> wrote in message
news:3F61FB70-63F0-43FC-92DD-7A720C5DF04D@.microsoft.com...
>I have a field which has a decimal place in the query results in report
> designer, but on a table in the report it doesn't show the decimal place.
> So
> a 10.5 shows as just 10. I already use the cint function to convert it
> from
> string to int, but that doesn't help. This was working, and I'm not sure
> if
> it's related it but I think after I upgraded to RS SP2 this started
> happening.
>