Change currency symbol in reports dynamically

  • Thread starter Thread starter SimeonD
  • Start date Start date
S

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
 
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.
 
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?
 
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 said:
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?
Click to expand...
 
Fair enough, thanks. I was trying to take the lazy way out, use replace
instead. Heh.


Klatuu said:
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.
Click to expand...
 
Back
Top