How do I stop Access 2003 changing the data I enter?

N

NoviceIan

A database I've been working on changes data I enter for example if I enter
37.5 it changes this to 38. The most annoying however is when it changes 0.5
to 0. Its driving me mad I've tried turning autocorrect in the fields
properties off but its made no difference.

The field does have an input mask if that makes any difference which is
9999.99

Hope somebody can help

Ian
 
B

Brian

NoviceIan said:
A database I've been working on changes data I enter for example if I enter
37.5 it changes this to 38. The most annoying however is when it changes 0.5
to 0. Its driving me mad I've tried turning autocorrect in the fields
properties off but its made no difference.

The field does have an input mask if that makes any difference which is
9999.99

Hope somebody can help

Ian
Click to expand...

You've probably chosen the wrong numeric size for the field. Take a look at
the "field size" property for the field, and you will find that is is
probably one of these: byte, integer, long integer. All of these can only
store integers (whole numbers).

To store decimals, you'll need to EITHER set the data type to Currency, OR
leave it as number and choose one of these sizes: single, double or decimal.
 
N

NoviceIan

Your a legend its works fine now. Thanks very much I wouldn't have thought
of that.

Ian
 
Top