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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
