• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

Change Currency Access


I have just downloaded the following access file

Asset tracking database - Access 2003 Version.

Now I want to change the currency from $ to Rs.

please can someone please guide me how to do it??

Rahul Sehrawat
Rahul Sehrawat
1 Solution
The fields that hold a currency have been formated to display $s.

To change this, you will need to go into the design view for each of the below tables in the database, click on the field that is a currency and in the field properties at the bottom, change the format from $s to your desired currency.
- Assets x 3
- Depreciation x 1
- Maintenance x 1

This will change the currency shown in the tables, however the fields on the forms have also been formated to show $s. In a similar way to the above, you will have to open the forms which display a currency in design view, then bring up the properties for the currency field (right click on it and select properties) and under the Format tab, Replace the $s with your currency next to the Format heading.
you can do it by changing the currency setting on your computer
here is a link that talks about this issue and how to change it

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now