Convert Numbers to string holding decimal places and point

[FrustratedPgmr]

I need to convert the number field with 2 decimal places to a string in a new field in another table. I must keep the decimal point even if it is ".00". i.e. 10000.00 will still be 10000.00 when it becomes a string. Currently it is converting as 10000. Has anyone else dealt with this? Any ideals would be welcome. I am stuck on this after 2 years of hard work. Help Please!

 

[vb6novice]

Format(CStr(mynumber), "#.00&quot

 

[vb6novice]

If you want at least 2 decimal places up to however many there are, then use

Format(CStr(mynumber), "#.00#&quot

The results of this might not be what you expect, depnding on the data type of what you are feeding it. You could get something like 10000.98000000000018 from a value of 10000.98.

 

[FrustratedPgmr]

Thanks for your quick response. It worked perfectly!!