Label in Report

[devcon]

I have a report and at the end of the report I want to include a label (bank details).
If currency Euro to use label euro, if currency US$ to use label US and if currency Singapore Dollars to use SGD.
Any suggestion please?

Thanks in advance.

See attached:


http://www.mediafire.com/file/hyyz2tmykhz/Report.pdf

[maximus]

assuming that currency is a field on the report.

place a label in the Report:

e.g. name of the label is label17

this code attached in the OnOpen Event.

Select Case Me.Currency
Case is = "$"
Me.Label17.Caption="Dollars"
Case is = "#"
Me.Label17.Caption="Pounds"
End Select

[devcon]

assuming that currency is a field on the report.

place a label in the Report:

e.g. name of the label is label17

this code attached in the OnOpen Event.

Select Case Me.Currency
Case is = "$"
Me.Label17.Caption="Dollars"
Case is = "#"
Me.Label17.Caption="Pounds"
End Select

Thank you.
Have a nice weekend.

Devcon

[maximus]

Please mark the thread solved if this solves your problem. this will help others with the same problem.