JackJackson54
asked on
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
Is there anyway to totally disable scientific notation in Access 2007
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My, I had never used the Fixed. Thanks as I have been struggling with this for a month.
Glad to help out :)
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.