Stop access from rounding up

Posted on 2003-03-03
Medium Priority
Last Modified: 2008-01-09
OK, so I **should** be able to stop this.....

How do I prevent Access 2000 from rounding 8.75 up to 9?  In the table, the field size is Double, format is General Number, decimal places 2.  The form based on that table, the format (for the field) is General Number, decimal places is 2.

If I enter the 8.75 directly into the table, it's fine, but when I put it in the form, it rounds up to 9.
Question by:dcurtis
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 26

Accepted Solution

Alan Warren earned 200 total points
ID: 8062408
In the table design

FieldSize = double
Format = Fixed
DecimalPlaces = 2


Author Comment

ID: 8062636

Expert Comment

ID: 8062890
I would use

FieldSize = single
Format = standard
DecimalPlaces = 2

This would use half the size of a double and would use commas for values over 999

Expert Comment

ID: 8063525
definately agree with alan warren, you want format = fixed and decimal places = 2

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question