Numbers keep rounding up

[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)

 

[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