Decimal places rounding to whole number

335 pts.
Tags:
Access 2003
Access forms
Microsoft Access
In my Access 2003 form values with decimal places are rounding to whole number. I've set the property to fixed formal with 2 decimal places and the problem continues.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Juju,

Sorry I misunderstood your question. If you DO NOT want rounding at all, then change the datatype to Single or Double.

If you have Long or Integer in as the datatype, then Access will only deal with the values as whole numbers and will automatically round up.

Randym,

THANKS! I changed the datatype to double and I am now able to display correctly (e.g. with 2 decimal places) You’re a life saver!

JuJu

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Juju
    Thanks for the info. I'll have to try this out!
    0 pointsBadges:
    report
  • Juju
    I wasn't clear -- I don't want my values to round and they are. E.g., I enter 1.50 and get 2.00. I've tried setting the number format to fixed with auto decimal places, fixed with 2 dec places, general with 2, etc and it continues to round. HELP!
    335 pointsBadges:
    report
  • Randym
    I have seen alot of misconception about using the number of decimal places and the format properties in the form. These are just the display format. They do not affect what is stored in the database. The data type of the column in the table must be Number with the field size of single or double if you want it to contain decimal places. A data type of currency will store only two decimal places. A data type of number with a field size of integer or long will store no decimal places.
    1,740 pointsBadges:
    report
  • tnie1509
    tq sooo much!!!i searched all day long on how to disable the round number..hahaaa..as simple as that..thanx a lot!!
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following