Format Currency

[Roger Bell]

I have the following text box in a report:

=Trim("Thank You for your Total Contribution of" & "" & [text235])

I would like the [text235] to be displayed as currency with 2 decimal
places. Could someone please advise where I add the Format Currency command
and the correct placement?

Thanks for any help

 

[Beetle]

=Trim("Thank You for your Total Contribution of " & Format(CCur( [text235]),
"Currency"))

 

[fredg]

I have the following text box in a report:

=Trim("Thank You for your Total Contribution of" & "" & [text235])

I would like the [text235] to be displayed as currency with 2 decimal
places. Could someone please advise where I add the Format Currency command
and the correct placement?

Thanks for any help

="Thank You for your Total Contribution of " & Format([text235],
"$#,##0.00")