Using Currency in text string.

[Homegrownandy]

Is it possible to display the value as currency in a text string? Its giving the correct value. In a form on a text box it displays correctly also.



But in a string its just the value and misses off the decimal and currency symbol.

[ranman256]

Convert it in the query...
cCur([field]

the textbox currency format will display it.

[Homegrownandy]

In a text box and in the query it is fine. But in a string in the expression builder its not. Seems odd

[CJ_London]

In a text box and in the query it is fine. But in a string in the expression builder its not. Seems odd

the text box and query formats are format properties for the underlying value. If concatenating to a string, the underlying value will be used. Instead you need to use the format function to convert the numerical value to a string

e.g.

mystring="The order value is " & format([field],"currency")

[Homegrownandy]

Brilliant. I probably could have found that with a little searching I assumed its format was pulled with the info. Appreciate the answer.