Decimal Places of All Things!!

[adfz99]

Hi,

I'm having a realllllly frustrating problem. I'm trying to enter the number 101.1 in a field, but whenever I enter it and hit tab to move to the next field it just truncates the number to 101. I've changed the number type, the number of decimal places, ect - everything! But it still changes my 101.1 to 101 after I move to the next field.

Help muchly appreciated.

 

[neileg]

Two questions

1. Where are you entering this? In the table, in a form?

2. What is the underlying datatype? You can see this in table design view.

 

[nicola1]

Well i had this problem...but just changed the datatype to memo....i didn't need to make any calculations with the number though!

 

[adfz99]

1. I'm entering the data into a form that I did up to link to the table.
2. The datatype for most of the table is text, but some are also set numbers

I've attached two images: one of the table and the other of the form I'm using.

Thanks for your time

 

[nicola1]

Do you need to make calculations on this figure? because if not just use the field type memo...i know its not the proper way but it sorted it for me!

 

[stephen81]

Have a look in table design view (like your first screenshot) and select the field in question and check what you've got in the Field Size propery.

 

[Smart]

Is the field on your form wide enough to hold the value ?

 

[RuralGuy]

I think the field is an Integer in the table. Change it to Currency if 4 places is enough or single/double if you need floating point.

 

[neileg]

Do you need to make calculations on this figure? because if not just use the field type memo...i know its not the proper way but it sorted it for me!

You don't need memo, just Text would have done. As you say, you can't use this field for calculations (unless you convert the contents to a number on the fly).

The datatype for most of the table is text, but some are also set numbers

As stephen81 and RuralGuy suggest, is the entry in the Field Size property (in table design view) than matters. If it is Integer or Long Integer, then any decimal values will be truncated an only the whole number stored. Single or Double datatypes will hold decimals, as will the currency datatype.