Currency from US$ to GBP (3 Viewers)

[Mario R. Perez]

Hello Group. I need to change the current currency from US$ to GBP. I know I need to update the text boxes in the forms and reports, but the problem is there are almost 100 objects. Is there a function that can iterate through the objects (forms and reports), update the currency fields, and save the changes?

Thank you so much for replying.
Mario
Lima Peru

 

[The_Doc_Man]

With basic out-of-the box Access, no. However there are third party Access project tools with varying degrees of editing support. One that has been mentioned many times is MZ-Tools, which you can look up online. It is a commercial product and is not free to obtain. I cannot personally recommend it for a couple of reasons, one of which is that I don't have it myself and have never used it. Therefore, my knowledge of it is strictly second-hand information. But various members have spoken in favor of it. I also want to clarify that the forum does not officially support any particular toolkit. I cannot speak for the forum when discussing a 3rd-party package. But if mentioning its name helps you, I can go that far.

Given the range of objects you have to change, I wonder, though, if you are facing a lot of manual edits anyway. I can only wish you luck on that.

 

[MarkK]

I need to change the current currency from US$ to GBP.

It's not clear what this means.
• Maybe you need to do a currency conversion from US$ to GBP at the current conversion rate?
• Maybe the currency symbol can just be changed in Windows regional settings?
• Maybe your textboxes have a custom TextBox.Format property value that explicitly uses the "$" character in that format?
Each of those might be what you mean. Each of those require a different fix.

 

[arnelgp]

you can also Save the Current Exchange rate of US$ to GBP to your table.
then using Query, you can Compute the Conversion of each field.