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