Solved How to disable Number rounding?

[SalmanZeiad]

i have problem when i put price 2.8 become to 3

 

[NauticalGent]

Need a little more information. Are you typing this into a form or directly to a table?

 

[SalmanZeiad]

Need a little more information. Are you typing this into a form or directly to a table?

form

 

[bob fitz]

If your table number field "Field Size" property is set to Integer change it to single.

 

[NauticalGent]

Thanks. Check the Format properties of that field. Specifically, the number of decimal places.

 

[bob fitz]

normal format decimal 2

The setting that I was referring to is a table field setting. It is not possible to set a number field to normal.

 

[The_Doc_Man]

Let's be clear. By default, Access shows you what is in the field. If you open the table and look at that value in Datasheet view, is it 2.8 or 3 ?

Rounding occurs when the data type of the field in the table doesn't support the precision you request. ANY of the integer types will do this, including LONG and INTEGER (a.k.a. WORD) data types. If the data type in the table is not SINGLE, DOUBLE, CURRENCY, or DECIMAL then you cannot have decimal points anyway. However, one can find general advice to avoid using DECIMAL anyway because of its issues in data handling.

Avoid Using Decimal Field Sizes in Microsoft Access Tables

Use Double rather than Decimal for Microsoft Access number field sizes

www.fmsinc.com

 

[SalmanZeiad]

Let's be clear. By default, Access shows you what is in the field. If you open the table and look at that value in Datasheet view, is it 2.8 or 3 ?

Rounding occurs when the data type of the field in the table doesn't support the precision you request. ANY of the integer types will do this, including LONG and INTEGER (a.k.a. WORD) data types. If the data type in the table is not SINGLE, DOUBLE, CURRENCY, or DECIMAL then you cannot have decimal points anyway. However, one can find general advice to avoid using DECIMAL anyway because of its issues in data handling.

Avoid Using Decimal Field Sizes in Microsoft Access Tables

Use Double rather than Decimal for Microsoft Access number field sizes

www.fmsinc.com

Also i check the table it`s 3

 

[SalmanZeiad]

The setting that I was referring to is a table field setting. It is not possible to set a number field to normal.

The setting that I was referring to is a table field setting. It is not possible to set a number field to normal.

Thank you>>>it`s work OK

 

[The_Doc_Man]

Also i check the table it`s 3

Yes, there is the problem. Bob Fitz's suggestion fixed you this time. For future reference, remember that the table in Datasheet view ALWAYS shows you the native format and accurate content of the field in question unless you have somehow adjusted the Datasheet View internal definitions - which is something even advanced Access user's don't do. So if there is EVER any question, the "true" display of your stored data is always found in the Datasheet view and is the first place to look to tell the difference between a data problem and a formatting problem.

 

[The_Doc_Man]

Forgot you could do that since it is something I knew to NOT do - because it cuts you off from important debugging information.
Thanks for the reminder, Pat.