How to stop Access from rounding automatically?

stylor

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?

Topic: Software
Answer this Question

Answers

2 total
jimlynch
Vote Up (15)

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...

TheCount
Vote Up (11)

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.

Ask a question

Join Now or Sign In to ask a question.
Microsoft's voice-activated digital assistant Cortana is coming to China in a beta version nicknamed "Xiao Na", as part of several new functions packed into a Windows Phone 8.1 update.
In response to a query from Vint Cerf, professional developers explain why they don’t feel a membership in the Association for Computing Machinery is worth the cost
An open-source project has released the first free application for the iPhone that scrambles voice calls, which would thwart government surveillance or eavesdropping by hackers.
Oracle has responded to a former employee's claim that a new in-memory processing option is turned on by default with the latest release of Database 12c, insisting that the process of enabling it requires a series of deliberate steps.
Today's hotels are unfortunately vulnerable to types of attempted fraud. Here's how to keep data safe when you travel.
Pushbullet is great for quick and dirty file swapping between your Windows PC and Android.
You probably didn't know you needed a color-coded goal manager or a dedicated email tracker.
Oracle has granted CEO Larry Ellison 3 million stock options, a significant reduction from the 7 million options he received in previous years, according to a regulatory filing.
The venerable GNU compiler wins the ACM’s Programming Languages Software Award while simultaneously coming under fire from the Linux creator
In the hot market for big-data products and services, sometimes even competitors must work together for the common good.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+