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

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.
In a move that could prove unpopular with IT administrators, Google has granted rights to end users of its Apps workplace email and collaboration suite to install third-party software from the company's Google Apps Marketplace.
With the release of its new mobile operating system on Wednesday, Apple has become the first smartphone maker to enable by default a kill switch that can lock and secure a stolen phone.
Continuing its efforts to bring business intelligence to the masses, software provider Qlik has released Qlik Sense, which is designed to provide business managers with an easy way to examine large data sets for insights and trends.
Dropbox's Datastore API, which gives apps a lightweight cloud database for storing structured user data, like settings and contacts, has been extended to let apps store data locally if users aren't logged into Dropbox.
Though many changes are geared toward consumers, IT shops have some new tools at their disposal as well.
Follow these tried-and-true techniques to improving both the speed and concurrency of your dawdling database.
Auth0, a provider of identity services that developers can build into their apps, scored a $2.4 million investment.
Box foresees a significant jump in usage of its iPad and iPhone app resulting from one of the new extensions Apple will launch with the new iOS 8.
VMware has upgraded desktop management tool Mirage with bandwidth control features and also published APIs to allow sharing of the data it collects.
European government agencies should adopt open document formats in their dealings with citizens, outgoing European Commissioner for the Digital Agenda Neelie Kroes has urged.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

randomness