Can't retain format type when concatenating

[darylclassen]

I have 3 items I want to concatenate into a single paragraph.

1.Openening sentence fragment (in text form)
2.Dollar value (in currency value)
3.Closing sentence fragment (in text form)

My problem is that I can't get the Dollar Value to retain it's currency formating in the resulting string. Tried CCur, but unsure of where to procede after this.

Any help is greatly, again, appreciated.
Thanks

 

[dhookom]

Apparently you want to keep the currency format within an expression. You can use the Format() function:
="You owe us " & Format([YourField],"Currency&quot & ". Please pay up immediately."


Duane
MS Access MVP