Solved: Access 2002 - automatically rounding field entry

[R1C1]

Hello,

I am not familiar with Access 2002. My co-worker has a database with several fields. In one field he enters a number, such as 2.1. This field is currently set as Text in his current database. He would like the entry to be an integer, not text. I switched it to Number and set the Decimal Places to 1. After this change, when 2.1 is entered, Access still rounds the number to 2. I tried changing the Field Size and Format to the different given choices and still can not maintain the decimal in that field of the table. I've Googled this and have not found the answer. I would appreciate any guidance you might be able to provide.

Thanks,

Alan

[R1C1]

Sorry for posting this inquiry. I found an answer from Dirk Goldgar at Microsoft.Public.Access.

"Make sure that the Field Size of the field in question is not one of the
whole-number types: Integer, Long Integer, or Byte. Those types can't
store any decimal places, by definition. Use a Field Size of Single,
Double, or Decimal, or a Field Type of Currency, to allow decimal places to be stored."

I set the field Single and Decimal Places to 1 and it maintains the decimal.

Thanks anyway,

Alan