Number field format trouble

  • Thread starter Thread starter Jonathan
  • Start date Start date
J

Jonathan

I am just learning how to use access and this seems like a
silly problem, but I can't figure it out. I have a series
of number fields and no matter whether I set the field
size to integer or long integer, and then format to
standard, fixed or general, Access is rounding the values
I enter up or down to whole numbers. Its not allowing me
to enter any numbers with decimal places. This is holding
true whether I enter the value straight into the table
datasheet or into a form. What's the problem?
 
Jonathan said:
I am just learning how to use access and this seems like a
silly problem, but I can't figure it out. I have a series
of number fields and no matter whether I set the field
size to integer or long integer, and then format to
standard, fixed or general, Access is rounding the values
I enter up or down to whole numbers. Its not allowing me
to enter any numbers with decimal places. This is holding
true whether I enter the value straight into the table
datasheet or into a form. What's the problem?
Click to expand...

Think back to math class. Integers are numbers that don't have any decimals. Since
Longs are just bigger Integers they don't either. You need to use either Single,
Double, or Currency.
 
Back
Top