Decimals, formatting maybe currency.

[Perfac]

When I enter a large amount say 2 200 005.46 access rounds to 2 200 006? When entering a smaller amount 155.46 it does not round it. I do set decimals to 2. Some time ago someone advised to format the field Currency since I generally format to STANDARD. When I format the field CURRENCY, it allows decimals. In South Africa the currency symbol is R for Rand. I do not want the currency symbol to show. And I need to use decimals. Thank you.

[orange]

Watch this short youtube video. Pay attention to Regional settings for ideas.

[Perfac]

I found the solution. Under regional settings where the currency symbol is, a space may be entered and that takes away the symbol.

[isladogs]

There's an easier way. Use currency datatype but format as Fixed. No space needed