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