Currency in textbox

[HaChIrish]

Is there a way to correctly display currency in a bound textbox that includes additional text? the text looks like something like this:

="Your current premium is "& [premium] & ". Please blah blah..."

The actual text is longer and more detailed then this example, but even with something simple like this the currency doesn't show correctly. If I drag n drop the field it displays fine, but as soon as I add an = sign it cuts off the decimal and takes out the $ sign. I tried decimalplace 2, setting format to currency, but nothing seems to work.

HELP!!!

 

[samehkh]

Try using

="Your current premium is "& FormatCurrency([premium],.......) & ". Please blah blah..."

Here is the syntax for the FormatCurrency function.
FormatCurrency(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

 

[Rich]

="Your current premium is "& Format([premium],"Currency") & " etc".

 

[HaChIrish]

Thanks to both of you. Rich's suggestion was a little easier on my puny brain to figure out, but it works like a charm!