Retain trailing zeros?

[Tekime]

I'm using a query to return negative currency values, and I need to convert them to positive values and include them in a string.

This code works fine except it strips all trailing zeros:

CCur(Abs(rs("trns_amount")))

I.E. -$123.90 would be returned as $123.9.

Is there a way to preserve the trailing zeros?

Thanks

 

[dcx693]

If you want to include them in a string, why use the CCur() function?

 

[Tekime]

You're right CCur is unnecessary. I tried it thinking it might convert the number into a currency format with the trailing zero's. (To no avail).

 

[Tekime]

Got it!

Format(Abs(rs("trns_amount")), "##,##0.00")