Display currency value in a string but retain the currency format

[s_m_chamberlain]

I am trying to concatenate if that's the right phrase a string and a currency value to form a sentance, but can't seem to retain the currency formatting. I'm sure this didn't used to be a problem, but it seems to be now?

For example I have a field called "Total Due" and I am trying to create an unbound text box on a report that has a value of: " return with your payment of "&[Total Due]&"."

The value of the field say is £57.00 in the table, but on the report the unbound text box displays: " return with your payment of 57."

Can anybody assist with this please? Many thanks.

 

[KenHigg]

I would think you could do this with

"Some text " & FormatCurrency(mycurrencyfld, 2)