Number format problem

[allanjf]

Hi
I have a numeric field (long integer) in a table. I've set the format to fixed. No matter what I set the decimal places to, auto, 0 or 2, when I enter a value of 0.71, it displays as 1.00
In my form, I've also set the field property to fixed, but it displays the value as 1.

Any suggestions as to what I am missing?

Thanks

 

[Mihail]

The field is declared as LONG INTEGER so, it can store only.... INTEGERS, isn't it ?
Change the field format to Double.
You can also change to Single but, from my experience, is not the best choice.

 

[pbaldy]

Any suggestions as to what I am missing?

Yes, a data type that can store a decimal.

Try currency, single, double or decimal as appropriate to your needs.