Access 2016 - Form is rounding inputs (1 Viewer)

B

Balota

New member

Local time

Yesterday, 21:18

Joined

Oct 14, 2018

Messages

4

• Oct 14, 2018

• #1

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?

 

B

Balota

New member

Local time

Yesterday, 21:18

Joined

Oct 14, 2018

Messages

4

• Oct 14, 2018

• #2

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?

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 19:18

Joined

Aug 30, 2003

Messages

36,124

• Oct 14, 2018

• #3

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.

 

B

Balota

New member

Local time

Yesterday, 21:18

Joined

Oct 14, 2018

Messages

4

• Oct 14, 2018

• #4

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.

 

J

JHB

Have been here a while

Local time

Today, 04:18

Joined

Jun 17, 2012

Messages

7,732

• Oct 14, 2018

• #5

Balota said:

..
Any clue what "Large Number" is supposed to mean? Apparently it's an integer of some kind.

Click to expand...

Large Number is:
https://support.office.com/en-us/ar...ata-type-5b623f6e-641d-4e97-8bdf-b77bae076f70

 

isladogs

MVP / VIP

Local time

Today, 03:18

Joined

Jan 14, 2017

Messages

18,209

• Oct 14, 2018

• #6

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.