Form: remove number rounding

  • Thread starter Thread starter maimiek
  • Start date Start date
M

maimiek

Form: remove number rounding, show actual value typed to 4 decimal places. I
type in 22.8656 and it shows 23.0000
 
Form: remove number rounding, show actual value typed to 4 decimal places. I
type in 22.8656 and it shows 23.0000
Click to expand...

This will typically happen if the underlying Table field is the
default Number datatype - Long Integer. A Long Integer is, by
definition, a whole number.

Change the datatype to a Number of size Double, Single, or Decimal; or
if you want four and exactly four decimals, use a datatype of Currency
instead.
 

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

Unwanted Numbers Rounding 6
Pivot table view does not show series data with decimals? 0
rounding problems 11
Don't want Access to round numbers to nearest integer. 1
Decimal places in forms 2
Excel Stop Excel from displaying rounded values 4
Round() Function 2
How do I stop rounding of my calculation results. 6

Back
Top