# is rounding. Do not want

  • Thread starter Thread starter cedia
  • Start date Start date
C

cedia

I need help. I have a field set as number. long integer
size, standard format with 2 decimals. the number keeps
rounding if i enter in a decimal number in the forms and
thru datasheet view of table. can someone help me?

thanks!
 
The Integer types (including Long) can store only whole numbers.

In table design view, change it to a Number of size Double instead.
 
You need to change the Data Type (Field Size) from Integer to Single or
Double, also change the Format and Input Mask if you have them. Since you
have already created the form, the setting changes won't be carried over
automatically. You'll need to go to the textbox on the form and set Format
and Input mask there as well.
 
Back
Top