Form: remove number rounding

M

maimiek

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

John W. Vinson/MVP

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

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.
 
L

Linq Adams via AccessMonster.com

It sounds as if the field is defined as an Integer. If so, change it to a
Single or a Double.
 

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

Top