Grrr. I don't WANT Access to round off to the nearest whole number

N

NC_Sue

So how do I make it display the number 4.78 without rounding up to 5 or (if I
set the input mask to #.##) to 5.00???
 
V

Van T. Dinh

Which data type and Field size do you have for the Field in the Table?

If you use Field Size Byte or Integer or Long, the Field sizes can only
store whole number and Access will automatically round the input to the
nearest whole number.

BTW, check Access Help for the differences between Format and InputMask. I
think you might have got the 2 properties mixed up.
 
Top