Access 2003

A

alex

I downloaded a template and its carency is ni $. How do i change it to S.A.
Rand (R1.00)
 
K

Ken Sheridan

The currency denomination is purely a matter of formatting. The underlying
currency data type is just a floating point number to a precision of four
decimal places, of which two are normally shown. The degree of precision in
the underlying data is to protect against cumulative rounding errors. You'll
need to change the Format property wherever the values appear formatted as
dollars in the application, particularly controls in forms or reports but
possibly also in columns in queries, and maybe even in table design. Use a
format such as R#,##0.00 which will present the values with a leading R, a
comma as the thousands separator and rounded to two decimal places.

Ken Sheridan
Stafford, England
 
Top