Problem with Number Data Type

[1953hogan]

I'm using Access 2997 and am pretty new to this. I have a table and a form with a number field:



The table has a field called

Field Name: CountUnitsPerPack
Type: long integer
format is general number
decimal places set to auto

I also have set up this field on my entry form, with the same properties:

format is general number
decimal places set to auto

The problem is that the field on the form does not accept decimal places:

If I enter the value "0.1" into the field on the form, the number "0" displays on the form. If I open the table, I see the value 0.1 has been entered into the field.

As I've said, the properties in design view show the field as a general number with decimal set to auto.

This is causing problems with some calculated fields, and I can't figure it out.

How do I get this form to accept and display a decimal (eg "0.1")?

Thanks in advance!

[boblarson]

Integers are WHOLE numbers. They do not have decimal places. Change to Single, Double, Decimal or Currency datatype.

[1953hogan]

Set the field to "single" and now all is fine. Sorry to have posted.

Steve

[boblarson]

Sorry to have posted.

Don't be sorry. That is what we're here for. If you don't know the answer, regardless of how basic it may SEEM after you get the answer, you still learned something and will probably never make that mistake again. Or, if you do, you will recognize it when you see it. So, don't be sorry for having posted. There was a time (a long time ago now) when I was in the same place you are and I made that mistake as well.