Currency Format (1 Viewer)

MattBaldry

Registered User.
Local time
Today, 20:55
Joined
Feb 5, 2019
Messages
130
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

I’m here to help
Staff member
Local time
Today, 12:55
Joined
Oct 29, 2018
Messages
16,519
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