changing text to currrency in report

[drfever]

On a report I want to insert a $ amount into my report from the table.
The field in the table is currency but inserted into the report as text.

How can I take a currency field insert into a text box and still show it as a currency or % ??

Example:

=" Your previous balance was" &[balance] "."


thanks for alll the help

 

[drfever]

THANKS FOR THE HELP !!!!!!!!!!!!!!!!