Currency Format (1 Viewer)

[MattBaldry]

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?

~Matt

 

[theDBguy]

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.