Change currency symbol in reports dynamically

[SimeonD]

Hi
I have an access database that now needs to deal with multi currency. Using
code, I have just changed the format on all text boxes in forms from Euro to
Standard.
I could do the same on reports, but it would be better if the currency
symbol was on the printed report, as it is given to customers. Can anyone
think of a way to do this?
Some kind of custom format?

Thanks
Simeon

 

[tedmi]

Yes, that can be done in the Open event of your report. You need to provide
the report with some indication of the nationality of the currency. Will all
figures on the report be in one currency? If so, you could pass the currency
symbol, or the formatting string, in the OpenArgs of the report.

 

[SimeonD]

All the figures will be in the one currency.
I've tried to write my own custom format, but how do I call a vb function
from the format property of the text box?

 

[Klatuu]

You can't.
If all currency in the report will be the same currency, then as tedmi
suggested, use the report's open event to supply the formatting.
--
Dave Hargis, Microsoft Access MVP

All the figures will be in the one currency.
I've tried to write my own custom format, but how do I call a vb function
from the format property of the text box?

 

[SimeonD]

Fair enough, thanks. I was trying to take the lazy way out, use replace
instead. Heh.

You can't.
If all currency in the report will be the same currency, then as tedmi
suggested, use the report's open event to supply the formatting.