Stop rounding my numbers!

  • Thread starter Thread starter Guest
  • Start date Start date
JunebugMarv said:
How can a prevent rounding of pre-defined number format (Percent)?
Click to expand...

How about a little more information?

That type of number (single, double, long integer ..?)

Do you want it truncate rather than round e.g. 1.28 = 1.3 or
1.2???

Where is this happening (control, form, query, table ...)?
 
How can a prevent rounding of pre-defined number format (Percent)?
Click to expand...

The Format is irrelevant. It just controls how the number is
displayed.

My guess is that you are using the default Number datatype, which is
Long Integer. An integer is, by definition, a whole number. Change it
to Double or Single and you'll be allowed 14 or 7 decimal places,
respectively.

John W. Vinson[MVP]
 
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

How can I cancel automatic rounding of numbers in Access? 2
Stop Rounding in Forms 2
Round up number 2
Preventing rounding numbers to nearest dollar 2
Rounding up! 2
stop automatic rounding 3
Numbers keep rounding automatically!! 1
Do not round percentage 1

Back
Top