Numbers keep rounding up

D

David Garlikov

I enter a number into a field in a record ie 4.3 and when
I leave the field, it changes to 4.0. I do not want the
numbers to round up or down. I tried using fixed,
general, standard and it does it in all of them.

It has to be something simple, but I have no idea what Im
missing.

Thanks,

David Garlikov
(e-mail address removed)0M
(replace the 3 zeros with the letter O)
 
J

JulieD

Hi David

sounds to me like the data type of the field is number - integer (or long
integer) where you want number - double
- go into design view of the table and have a look at the field properties.

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number automatically rounds up 1
How do I stop my number fields to round up? 5
Round up number 2
Round up or down to nearest 5, but not 10 2
Numbers keep rounding automatically!! 1
ROUNDING UP TO THE NEXT WHOLE NUMBER 3
Rounding Up to next whole number 6
Why does my numeric fields round decimals off? 1

Top