Decimal places rounding to whole number
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 25, 2008 9:08 PM
UPDATED:
October 2, 2008 5:20 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
Thanks for the info. I’ll have to try this out!
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!
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.