Automatic rounding up of numbers

[kezza_47]

when enetering data into a field on a form it automatically rounds it up the number up to the nearest whole number. this is really frustrating, does anyone know how i can solve this problem?

thanks

 

[allan57]

under the text box properties enter:-

format = standard
decimal places = (enter integer of required number of decimal places)

 

[kezza_47]

thanks for reply but didnt work

hi allan

thanx for your reply but unfortumatly that didnt work now it just rounds the number up to 2 decimal places i.e i enter 18.76 and will display 19.00

does anyone else have any other suggestions???????

 

[Rod D]

I know this may seem like a stupid question, but have you defined the field type in the table as "Long Integer"? - This is the Access default.

As Integers (by definition) cannot hold decimal places, rounding up will always happen. If you find that the field is defined as "Long Integer" in the table, change it to either "Single" or "Double" and try again.

Just a thought...
Rgds
Rod