Link to home
Start Free TrialLog in
Avatar of JackJackson54
JackJackson54Flag for United States of America

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
Avatar of mbizup
mbizup
Flag of Kazakhstan image

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.
Avatar of JackJackson54

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
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My,  I had never used the Fixed.  Thanks as I have been struggling with this for a month.

Glad to help out :)