) with the currency values on a data access page, use an expression. For example, if a field called EuroValue contains currency values, you can use the following expression in the ControlSource property of a calculated control: On a data access page, when you display a field that has a Currency data type (Microsoft Access database), or money data type (Microsoft Access project), the page uses the currency symbol specified in Regional Settings in Windows Control Panel of the computer on which the page is displayed. The field doesn't inherit any format, including the currency and euro formats, specified for that field in the underlying record source.
To display the euro symbol () with the currency values on a data access page, use an expression. For example, if a field called EuroValue contains currency values, you can use the following expression in the ControlSource property of a calculated control:
IIf(EuroValue>=0, Format(EuroValue,"#,##0.00"), Format((EuroValue*-1),"(#,##0.00)"))