Forum home » Delegate support and help forum » Microsoft Access Training and help » Currency in forms - access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Currency in forms - access
Resolved · Low Priority · Version 2003
Reply Tue 28 Oct 2008, 16:41Delegate Thomas said...
Thomas has attended:
Access Intermediate course
Currency in forms - access
If a currency is set in a form will this change if users are viewing the same access database from different countries. As the currency is by default set to the control panel settings. If so how could this be overcome without changing user settings.
For upcoming training course dates see: Pricing & availability
RE: Currency in forms - access
Dear Thomas
Thank you for attending Access Intermediate!! I hope you enjoyed the course and benefited from it.
If you want $ sign in front of all the numbers set as currency regardless of the control panel setttings please follow these steps:
Open the form in design view
Right-click on the field that you want to customise the field. (please ensure that you right-click on the white box and not the label)
Choose Properties from the short cut menu.
In the forrmat section type in the following:
$#,##0.00;($#,##0.00)
If you want to use teh
|