Last two 00 digits being chopped on Report 1

[bluedollar]

I have a text box in a form, which is set to format = fixed. The text box takes a currency value and shows it as below:

xxxx.xx

This works fine, however when I take this value from the textbox and try and use it in a report, the digits after the decimal point get chopped (but only when the last two digits are 00).

I am getting the value into the report by setting a text box control value (in the report) to:

="TOTAL £ " & [Forms]![Quotation_design_wizard]![price]

Does anyone know how to stop the last two digits being chopped?

Any help would be greatly apprecaited.

Thanks

Dan

 

[SgtJarrow]

try...

="TOTAL £ " & CStr(Format([Forms]![Quotation_design_wizard]![price], "0000.00&quot)


****************************
Computers are possibly the most un-intelligent things ever invented, yet we let them control the world. Possibly a reflection of our own stupidity.

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com