Access data type help

[Johanb26]

Hi guys,

In our database we have a few fields with number as the data type. But the values entered range between 0.001 - 0.200 when we enter this in our database for example 0.080 access automatically trims the value to 0.

The field size we use is Double with decimal places as 4. I have also updated the database and changed the field size to decimal with 4 decimal places as well and we still get the same result.

Is there a way to overcome this and what happened to all the data that have been inserted that have now been changed to 0 ?

On other fields we have the Double field size, but then we have to enter data like 5,8 and access changes the value to 6. Is there a way to cancel the rounding of numbers in access ?

[ItsMe]

Use the Decimal Places property at the Table Layer to control floating point vs. fixed.

If your data is being truncated and the field in the table is Double, you are most likely truncating the data before the table ever sees it. Take a look at your controls and or variable types. It seems you are using an integer type somewhere.

[Johanb26]

Use the Decimal Places property at the Table Layer to control floating point vs. fixed.

If your data is being truncated and the field in the table is Double, you are most likely truncating the data before the table ever sees it. Take a look at your controls and or variable types. It seems you are using an integer type somewhere.

When viewing the table, the data in the table is already truncated to 0 instead of showing the 0,017 value.

[ItsMe]

When viewing the table, the data in the table is already truncated to 0 instead of showing the 0,017 value.

Yes, I understand. Consider the method used to populate the field if the field is of Type Double.

[ItsMe]

I am viewing the table in design view and it has the following properties:


Data type: Number
Field Size: Double
Format:
Decimal places: 4
Input mask:
Caption
Default value:
Validation rule:
Required: No
Indexed: NO
Text Aling: general

I have no idea where else to set the settings to change the data so that 0.001 etc won't be rounded to 0.

The data is entered in a form though with a txtbox.

On the txtbox the format is empty, and decimal places is set to 4.

Is the user typing directly into the Textbox? Try formatting the textbox. Use the Format tab on the property sheet for the textbox control. In the Format Field, select "General Number".