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

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

"tedmi" <te...@discussions.microsoft.com> wrote in message
news:01C5CF7B-B6F8-4F8E...@microsoft.com...
> 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.
> --
> TedMi
>

[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

[SimeonD]

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

"Klatuu" <Kla...@discussions.microsoft.com> wrote in message
news:D1E5491B-2FCC-4384...@microsoft.com...

[tedmi]