This problem occurs when all the following conditions are true.
- The table is created in DataSheet view.
- The first value that you enter in the first row of the column is an integer value.
- Click the DataSheet tab. In the Views group, click the arrow under View, and then click Design View.
Note If the table has not already been saved, you will be prompted to save the table with a table name that you provide.
- Locate the column that you want to change, and then set the Field Size property of the column to Double or to Decimal.
Note If you set the Field Size property of the column to Decimal, you must also set the Scale property of the column. When you set the Scale property, you specify the maximum number of digits that can be stored to the right of the decimal separator.
- Save the table.