Changing currency in this Access template

Please don't revive 5 year old threads.

While I appreciate this is an old thread I've only recently come across this problem and found a solution to it having first visited this thread and found what was suggested very unhelpful. There will be others coming across this problem and if they visit this site as I did then perhaps this old but relevant reply will help.

There is another update to this problem discovered this morning which might be a quicker solution to this original problem.

Open a table, highlight the field, on the ribbon select Fields, and in the Data Type/Format select currency. You will need to do this for each relevant field and it should automatically update the Forms, queries and reports although I cant be sure as I discovered this only after making the changes as described in the previous thread.

Hope this helps.

Hello,

I have found a useful Access template for my small business, however I am based in the UK and want to change the currency value from $ to £. Is there any way to do this?

Here's the template: http://office.microsoft.com/en-us/templates/results.aspx?qu=inventory&ex=1&origin=CT010214400#ai:TC102483123|

Thanks in advance,

James

You will have probably sorted this by now but there may be others suffering for an answer to this problem.

There is no signal setting to change but once you have them all changed that is it.

Your tables ignore them.

Go to your forms and reports to make changes.

Open each in  Layout view, highlight relative field, click on Property Sheet from the ribbon, select the format tab and from this list select currency of your choice. Do this for all instances in the form or report and when finished close and save.

You may need to do this a dozen time depending on the template but as I've said once done your done.

May be this would work but I'm not sure:

Open the "Products" table in design view.  The "Unit Price" field is a currency data type.  Change the "Format" property of this field from $#,##0.00;($#,##0.00) to £#,##0.00;(£#,##0.00)

There is another currency type field in the "Purchase Orders" table and in the "Inventory Transactions" table that would also need to be altered.

You may find that any text box controls on forms and reports that display a currecy will also need to have their Format property changed as well.

Please don't revive 5 year old threads.