 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008Change currency symbol in reports dynamically
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.  SignatureTedMi 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? > Yes, that can be done in the Open event of your report. You need to > provide [quoted text clipped - 3 lines] > currency > symbol, or the formatting string, in the OpenArgs of the report. 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. SignatureDave 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 [quoted text clipped - 7 lines] > > currency > > symbol, or the formatting string, in the OpenArgs of the report. 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 [quoted text clipped - 12 lines] >> > currency >> > symbol, or the formatting string, in the OpenArgs of the report. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.