How do I prevent a number from rounding in Access?

[KL2111]

If I enter a number with a decimal, Access rounds the number. For example 1.5
becomes 2, etc...

 

[Tom van Stiphout]

On Tue, 10 Nov 2009 21:02:16 -0800, KL2111

Perhaps you have the control bound to an Integer field. Use Double or
Single instead.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

If I enter a number with a decimal, Access rounds the number. For example 1.5
becomes 2, etc...

The default Number datatype is "Long Integer". An Integer is, by definition, a
whole number, and Access will round it.

If you want to store a number with decimals, use either Number... Single
(floating point, up to seven digits precision, possible roundoff error
problems), Number... Double (floating point, up to fourteen digits, same
problem), or Number... Decimal (you set the precision and number of decimals);
or use a Currency datatype (exactly four decimals, no roundoff error).