Decimal Places Problem

[GeekGirlau]

I have a field defined as Single data type, Fixed format with 3 decimal places. When I type a value that has 3 decimal places, the last digit is rounded so that it always displays as zero. So if I type 15.752 I get 15.750, 1.105 becomes 1.110 etc.

Any ideas?

 

[CosmoKramer]

Instead of fixed, try a format of 0.000.....

 

[GeekGirlau]

Thanks Cosmo.

Limited success - some records seem to work fine, and others round the decimal places! Have rebuilt the table and imported the data into it to see if this works.