why are my numbers getting rounded???

[JumpinJimRivers]

Hello,

I believe I have tried every number type, every number format and for some reason my number field that has 2 decimal places is getting rounded to the nearest whole, and is storing that way! What is going on here???

 

[TomCologne]

Have you tried setting "Field Size" to "Single" or "Double"?
If it is set to "Integer" or "Long Integer", all decimal settings will be ignored.

You're not alone,

TomCologne