Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-13-2018, 06:45 PM   #1
Balota
Newly Registered User
 
Join Date: Oct 2018
Posts: 4
Thanks: 3
Thanked 0 Times in 0 Posts
Balota is on a distinguished road
Access 2016 - Form is rounding inputs

After much hairpulling, I managed to figure out that both the table and the form need to agree on the format. I settled on Fixed format with 3 decimal places for the specific field I'm interested in. When I try to enter the molecular weight of methane (16.043) the form shows my input as 16.000. I cannot find any place on any Property sheet that allows me to select Single or Double precision, only the choices for Format: General Number, Fixed, Currency, etc.

How do I get Access to just take the value I enter and use it?

Balota is offline   Reply With Quote
Old 10-13-2018, 07:11 PM   #2
Balota
Newly Registered User
 
Join Date: Oct 2018
Posts: 4
Thanks: 3
Thanked 0 Times in 0 Posts
Balota is on a distinguished road
Re: Access 2016 - Form is rounding inputs

Sux getting old. Try never to do it.

My field was specified as Large Number. That's because when I tried Number, it wanted to use Long Integer. Finally figured out that I could change the Long Integer selection to Double. Duh.

But now my curiosity is getting the best of me. What the heck is a "Large Number"? Isn't a Double (10^308 or so) large enough?
Balota is offline   Reply With Quote
Old 10-13-2018, 07:29 PM   #3
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,929
Thanks: 9
Thanked 3,844 Times in 3,787 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Access 2016 - Form is rounding inputs

Integer types only store the integer value, no decimals. You might consider Currency or Decimal; Double is a floating point type and can have odd results, like 2+2 not = 4.

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
Balota (10-13-2018)
Old 10-13-2018, 07:55 PM   #4
Balota
Newly Registered User
 
Join Date: Oct 2018
Posts: 4
Thanks: 3
Thanked 0 Times in 0 Posts
Balota is on a distinguished road
Re: Access 2016 - Form is rounding inputs

Understood. Just couldn't find the spot where I could change the Number from Long Integer to Double. Finally did find it. And Double is what I need for other reasons.

Any clue what "Large Number" is supposed to mean? Apparently it's an integer of some kind.
Balota is offline   Reply With Quote
Old 10-13-2018, 09:09 PM   #5
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,352
Thanks: 2
Thanked 1,971 Times in 1,927 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Access 2016 - Form is rounding inputs

Quote:
Originally Posted by Balota View Post
..
Any clue what "Large Number" is supposed to mean? Apparently it's an integer of some kind.
Large Number is:
https://support.office.com/en-us/art...f-b77bae076f70
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
Balota (10-14-2018)
Old 10-13-2018, 11:44 PM   #6
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,552
Thanks: 88
Thanked 1,609 Times in 1,499 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Access 2016 - Form is rounding inputs

Avoid using large number datatype unless you really need it.
It will prevent your database being opened in earlier versions of Access - anything other than 365 or 2019 won't accept it.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Web links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders

Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Balota (10-14-2018)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form not loading for all users - Access 2016 logbran Forms 9 08-14-2018 04:47 AM
Creat Search Form By Date, Access 2016 tihmir Forms 15 05-01-2018 09:02 AM
Controls aren't resized with form after upgrade to Access 2016 wisekat Forms 0 04-19-2017 11:46 PM
Deploying Access 2016 Front End, Access 2016 RossWaddell General 2 07-24-2016 05:43 AM
How to calculate metric based on two or three inputs - please help access greenhorn Pavel_Janu Queries 3 05-28-2008 06:50 AM




All times are GMT -8. The time now is 05:45 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World