How do I prevent my numbers from rounding in tables, forms, and reports? I have specified standard format with 1 decimal place. However, Access keeps rounding up/down and giving me a 0 for all decimals...
You will have to go back to each and every reference for them to make sure that all formats are set correctly. Also, review the actual table that is calling them to make sure the data is in it correctly.
I had the same problem with rounding numbers even after checking all the properties in my forms and tables. You might also want to try changing the field size for your number field from Long Integer (if that is what it is set at) to Single or Double in the property settings on the original table. Single or Double allows for a more precise decimal setting.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.