• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4021
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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