Format of combined text & controls

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

I have text box on my report that is combining fields from
a table sandwiched between text.

Ie: ="Your current balance is " & [Field1] & " more text
here... "

My problem is that the field I am using is a numeric
field. I want this to show up as currency, however it
shows on the report as with no formatting.

---------
Result is: Your current balance is 547548.47 more text
here...

Desired result: Your current balance is $547,548.47 more
text here...
-----------

Of course, I could add a $ to the text, but I still need
commas to separate the thousands. Lengths of the field
vary significantly, so putting a separate control on top
of the text paragraph would not work. The table data is
set up as currency, but that does not translate to the
report. Changing the format property has no effect
because of the text.

How can I make this show up as $? Thanks!
 
Thomas said:
I have text box on my report that is combining fields from
a table sandwiched between text.

Ie: ="Your current balance is " & [Field1] & " more text
here... "

My problem is that the field I am using is a numeric
field. I want this to show up as currency, however it
shows on the report as with no formatting.
Click to expand...


Use the Format function:

="Your current balance is " & Format([Field1], "Currency") &
" more text here... "
 
Back
Top