I am working with a table that someone else designed. The field is designated as a number. I want to enter a 2 digit number with one decimal place. [Ex: 27.5] The field is automatically rounding to the ones place with a 0 in the tenths place. (27.0) The field size doesn't matter, I have tried them all. I put in formatting and an input mask, however it still automatically rounds.
A:
Check the table definition.
If it's a Number, it can be an Integer (Byte, Integer, Long Integer) type or a Real (Single, Double, etc.) The integers will always round. Also, if you are using a real type, the Decimal option may have an effect as well
CodeSlave
2010-08-12 20:58:21
...but the decimal property affects only display, not the actual precision of the stored data.
David-W-Fenton
2010-08-13 00:24:24
Apparently I hadn't tried them all. As soon as I read the Single and Double in your post, I thought, yeah I saw those, but since I wanted a 3 digit number that wouldn't work. However, that is why I asked the question, because I was taking those titles to literally.
Excel-dummy
2010-08-13 14:43:08
Thank you Code Slave. I was able to use Single for the field size(which allows for decimal precision to 7), 1 decimal place, and the input mask. Thank you for telling me that the INTEGERS will always round. That is what was really frustrating me, since I couldn't find anything stating that it was rounding.
Excel-dummy
2010-08-13 14:52:29