Currency Format (1 Viewer)


Self Taught, Learn from the Forums
Local time
Today, 17:55
Feb 5, 2019
Hello forumers,

Is there a way to change the currency format for currency fields in a report based on a lookup to the select currency on an order? At the moment I have a drop down to select the currency. When this goes into the report I have the data source as (an example) [CurrencySymbol]& " " & [LinePrice]

This does not show as a proper currency field as if there are no decimal places, it shows as a round number. I have added Format([LinePrice","Standard"), but this seems like a long winded way of doing it.

Is there a way I can lookup, when the report is opened, to the currency selected in my drop down and then change the field format type to suit the currency used?



I’m here to help
Staff member
Local time
Today, 09:55
Oct 29, 2018
Hi Matt. Just thinking out loud... The Format() function returns a String, so maybe you can use the Replace() function to change the currency symbol to what you really want to use.

Users who are viewing this thread

Top Bottom