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 (10)

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 (9)

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.
Sure, you’ve changed a bunch of passwords, but are you doing all you can to protect yourself?
Google did little during its first-quarter earnings report to shush critics who say its Enterprise unit is a second-class citizen in its kingdom.
This week on World Tech Update, Google confirmed its acquisition of drone maker Titan Aerospace, a move poised to advance delivery of the company's data services and mapping applications.
Red Hat has successfully grown Linux into an enterprise platform, now it's looking to do the same with OpenStack
Facebook now has its own take on location sharing -- an optional feature that periodically broadcasts people's locations to their friends.
Yep, a lot of folks are using Apache OpenOffice -- despite the fact that many Linux distros now default to LibreOffice.
Whether it's the first time you've picked up an iPad or the seventeenth time you've pulled out your iPhone today, there are probably still some iOS 7 features and functionality that you're not familiar with. Don't sweat it: We're here to help. We've collected some of our favorite and most useful tips and compiled them here, just for you.
The early reviews of Ubuntu 14.04 LTS are out, find out what the critics think of Trusty Tahr.
Oracle is gearing up for a fight with officials in Oregon over its role developing an expensive health insurance exchange website that still isn't fully operational.
SAP reported a strong growth in cloud revenue and fast adoption of its HANA platform in the first quarter, while its software revenue dipped from the same quarter in the previous year.

White Papers & Webcasts

See more White Papers | Webcasts

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

randomness