s
stylor
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?

jimlynch
07/12/2013
This thread might be useful.

How do I stop Access rounding up the figures I enter in to a form
http://msgroups.net/microsoft.public.access.forms/how-do-i-stop-access-r...
T
TheCount
07/11/2013

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.

Answer this
ASK a question
250