Enclose my MS Access currency text to include quotation marks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my report, I need to enclose my total currency data in quotation marks
(i.e. "$1,000.00") without losing my formatting.
 
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") & """"
 
You must log in or register to reply here.

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

Quotation Marks as Text 2
Formatting data tables in reports with graphs 2
A lingering question about suppressing ", " in concatenated expression (=lastname&", "&firstname) 1
Converting Numbers from Excel to TXT files 2
Importing Data for use in report 19
Inability to add quotation mark around a variable by concatenation in VBA 4
problem with automatic quotation marks 1
Report Formatting - Type/Sub-Type 2

Back
Top