Decimals in number fields automatically rounding

[browninaz]

Hello everyone,

I have created a sub form in a form that allows data entry for order details. I have a column that holds order amounts that automatically rounds up or down, and I don't want this. How do I fix this issue? I have examined the back end table properties for this particular field, and the number field is set to general. Is there something I am missing?

Thanks to all who know more than me...

 

[pbaldy]

What is the data type and field size of the field? My guess is the field size is Integer or Long Integer, neither of which can hold a decimal.

 

[browninaz]

Thanks for the quick response Paul,
The field size is set to Long Integer. What should I set the field size to?

 

[browninaz]

Never mind Paul,
I figured it out. Set to double.

 

[pbaldy]

That should work, as will single and currency.