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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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.
 
You must log in or register to reply here.

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

rounding up to the nearest whole number 1
Preventing rounding numbers to nearest dollar 2
Rounding up! 2
Access 2007: % fields rounding to nearest integer 3
rounding up to nearest specified whole number 1
Rounding to nearest whole number??? 4
Access Round() Function Question 5
Stop Rounding in Forms 2

Back
Top