Why wont my control accept decimal places?

[Tony Williams]

I have a form based on a table. There are a number of numerical controls
that I want to input data to 3 decimal places. I have tried setting the
field property to Long Integer with a format of general number with 3
decimal places and it appears to round down my numbers to the nearest whole
number. EG I input 14.281 and automatically get 14.000! I have tried various
other formats but can't seem to get my 3 decimal places. What's wrong?
Thanks
Tony

 

[Guest]

You need to set the field property to double because Integer means a whole
number

 

[Tony Williams]

Thanks Dennis did the trick
Tony

You need to set the field property to double because Integer means a whole
number