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

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.
Mark Pincus, who founded Zynga in 2007 and gave up his CEO title less than a year ago, is now giving up all his operational duties at the company.
Quip has released an API for its browser-based word processor that it hopes enterprise developers will use to make the application do more jobs in workplaces.
China is working on a Linux operating system that can replace the now-vulnerable Windows XP and protect the country's networking infrastructure.
Roughly a year after settling an ugly, protracted legal battle with Oracle, Montclair State University is planning to implement a rival vendor's ERP (enterprise-resource-planning) system.
A notorious Windows leaker dubbed 'Wzor' says Microsoft will issue yet another update to Windows 8.1 later this year, evidence of an even-faster acceleration in the company's development tempo.
Apple today followed Microsoft in opening up pre-release, or beta, versions of its personal computer operating system to all comers.
If something about iOS 7.1 just didn't sit right for you, no worries: Here comes iOS 7.1.1 to give it another shot.
Small businesses increasingly turn to Square to process payments without the hassle (and expense) of custom card-reading hardware. There are other benefits to the service, including analytics and online sales modules, as well as opportunities for larger enterprises to better serve customers.
It's more about stability than new features, but still begins a new era for Ubuntu.
Microsoft may have retired Internet Explorer 6 last week, but it's still keeping track of the ancient browser's user share on a death watch-like website that's been running for more than three years.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+