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.
Borrowing a page from the recently revised Microsoft playbook, development tools maker Telerik has released as open source the bulk of its Kendo software library of components for building Web and mobile applications
Although Exadata is Oracle's most popular and mature "engineered system," some customers implementing the database machine are making mistakes that prevent them from getting the most performance out of the expensive product, according to a veteran of many Exadata projects.
Even four months after the Mac Pro's initial release, Apple appears to be having problems making enough of the high-end cylindrical desktop computer. The company's store currently shows shipping times of 4-5 weeks for all Mac Pro models, even the stock versions without additional customizations.
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.

White Papers & Webcasts

See more White Papers | Webcasts

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

randomness