Enclose my MS Access currency text to include quotation marks?

7

70s_RocknRoll

On my report, I need to enclose my total currency data in quotation marks
(i.e. "$1,000.00") without losing my formatting.
 
F

fredg

On my report, I need to enclose my total currency data in quotation marks
(i.e. "$1,000.00") without losing my formatting.

Use an unbound text control.
= """" & Format([ControlName],"Currency") & """"
 
Top