• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3518
  • Last Modified:

Turn off Scientific Notation in Access

I have tried all kinds of formats on numbers and can not stop Access from  scientific notation.  All of the numbers are Double or Decimal.

Is there anyway to totally disable scientific notation in Access 2007
0
JackJackson54
Asked:
JackJackson54
  • 3
  • 2
1 Solution
 
mbizupCommented:
AFAIK, you cannot totally disable scientific notation.

However you can change the formatting of individual controls on your forms and reports, for example by selecting "Fixed" and specifying a number of decimal places.
0
 
JackJackson54Author Commented:
I have tried using 4 decimal places and it continues to use scientiific notation.  It does not use scientific notation on all the numbers - just some of them.
0
 
mbizupCommented:
Just verifying that under the FORMAT tab in the property of your textbox or other control you have:

- Selected Fixed for the format property
- Used 4 for the number of decimal places
0
 
JackJackson54Author Commented:
My,  I had never used the Fixed.  Thanks as I have been struggling with this for a month.

0
 
mbizupCommented:
Glad to help out :)
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now