# is rounding. Do not want

[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!

 

[Allen Browne]

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

In table design view, change it to a Number of size Double instead.

 

[Wayne Morgan]

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.

 

[cedia]

Awesome!!

problem solved.Thanks a million everyone!