Is it possible to format the result of an expression in a text field? I would like the output to be in a currency format rather than just a regular number with unlimited decimal places.
Yes, you can use the Money() function, or even the Num() function like this:
Hope that helps.
and what if id like the currency without the pence?
Then use the Num() with the format you want. Say the value is 10000 and you want to represent it like "$10,000" or the value is -2300 and you want to represent it like "($2,300)", then the format should be:
Miguel thats excellent, thank you so much for your help.
Retrieving data ...