Jul 11, 2013

How to stop Access from rounding automatically?

Access 2013 rounds entries in the number field automatically, so that when I type in, say, 99.83, it gets changed to 100. How can I make it leave the number as I enter it, with decimals?

I just wanted to say that I really appreciate your help! I was getting frustrated trying different formats. Thank you!
This thread might be useful.

How do I stop Access rounding up the figures I enter in to a form

Open table in design view and click the field that you are having issues with. Click the Field Size box on the General tab, then click the down arrow at the end of the box to choose Decimal on the resulting drop down menu. Save the table, and it should no longer automatically round.

Thank you! I was frustrated and this helped me out so very much.
Answer this