Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008

    Unanswered: Stop Access auto rounding Currency field

    Hi Guys

    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!


  2. #2
    Join Date
    Aug 2008
    (Using 2002)

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    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..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts