Display different currency symbol

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I have customers who pay in either US Dollars or Euros and
have created a currency table to report how customers pay.

In the payments report I can produce a field which
generates a currency symbol (black or red for positive and
negative balances) but can I customise the field to select
the appropriate currency symbol for each customer?
 
I have customers who pay in either US Dollars or Euros and
have created a currency table to report how customers pay.

In the payments report I can produce a field which
generates a currency symbol (black or red for positive and
negative balances) but can I customise the field to select
the appropriate currency symbol for each customer?
Click to expand...

Your table has a field that indicates Dollars or Euro's?
If so, add a small unbound control to the report.

Code the Detail Format event:
If [HowPayField]] = "Dollars" Then
[ControlName] = "$"
Else
[ControlName] = chr(128)
End If

If you wish, you can combine the sign with the amount:

If [HowPayField]] = "Dollars" Then
[ControlName] = "$ " & [Amount]
Else
[ControlName] = chr(128) & " " & [Amount]
End If
 
Back
Top