Solved

Change Currency Access

Posted on 2011-09-28
2
332 Views
Last Modified: 2012-05-12
Hey,

I have just downloaded the following access file
http://office.microsoft.com/en-us/templates/results.aspx?qu=access&av=zac110#ai:TC001018459|

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??


0
Comment
Question by:Rahul Sehrawat
2 Comments
 
LVL 2

Accepted Solution

by:
jdc1944 earned 500 total points
ID: 36715646
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.
0
 
LVL 10

Expert Comment

by:conagraman
ID: 36718458
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

http://allenbrowne.com/ser-44.html
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question