Display different currency symbol

[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?

 

[fredg]

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?

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

 

[Jennifer]

Thanks Fred - You're a star!

 

[Jennifer]

Thanks Fred - You're a star!

 

[Jennifer]

Thanks Fred - You're a star!