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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inability to add quotation mark around a variable by concatenation in VBA 4
Quotation Marks as Text 2
Converting Numbers from Excel to TXT files 1
How to copy only the numbers that are between quotation marks in new cells 1
problem with automatic quotation marks 1
report parameter from listbox 2
How to keep loaded file's format intact? 1
Report Formatting - Type/Sub-Type 2

Top