Csrt() and Decimal’s

[Bennie47250]

I’m taking a Decimal field and converting it to a string using the Cstr() function so I can concatenate several fields together.

In the Decimal field in the table the number's look like 560.00 and 4.30 but after it is converted it looks like 560 and 4.3. How can I have the zero’s show up after it has been converted to a string?

Thanks

 

[PHV]

Have a look at the Format function instead.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bennie47250]

Resolved this by using both the Format and Cstr function

Format(CStr([MyTable]![MyDecimalField]),"Fixed")