Concatenated string with currency formatting on one value

  • Thread starter Thread starter Steve R. via AccessMonster.com
  • Start date Start date
S

Steve R. via AccessMonster.com

I have the following string as the control source in an unbound text box in
my Access report - at the end of the string, I want to put a currency
formatted value. The field is called "VALUE" - as a work-around, I placed
and unbound text box with VALUE as the control source, and it works fine, but
I would like to include the VALUE field in my string without the work-around
extra text box

=" purchased from " & [VendorName] & " Target Value:"

(Then to the right of that text box, I include another text box just to hold
the value

If I put "target value:" & [Value] at the end, it just shows the number with
no formatting


Can this be accomplished in the string, or am I resolved to using this work-
around ?

Thanks in advance,
Steve
 
Insert a Format statement that applies just to the value portion of your
string:

=" purchased from " & [VendorName] & " " & Format([Value],"$#,##0.00##")

You can customize the #/0 combinations to either allow or force existence of
characters at these positions.
 
Back
Top