var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stop Access auto rounding Currency field
I know this sounds like a silly questions, but I can't seem to stop Access auto-rounding data I put into a currency field on a form.
For example, if in enter 0.79p it auto rounds it up to £1.
Any ideas how I can disable this?
Thanks in advance!
Is the data type of the field Currency?
What is the Decimal Places setting on... for both the field in the table and the text box on the form?
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "