As posted very frequently in these newsgroups, sound like your field is
defined as an integer. An integer, by definition, is a whole number (no
decimals).
Assuming that the data type for the field in the underlying table is
Numeric, what's the Field Size?
The default for Numeric is Long Integer, which will exhibit this behaviour
(integers cannot contain fractional values). Change the Field Size to Single
or Double.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.