Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Turn off Scientific Notation in Access

Posted on 2011-09-19
5
Medium Priority
?
3,301 Views
Last Modified: 2012-05-12
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
Comment
Question by:JackJackson54
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 36560436
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
 

Author Comment

by:JackJackson54
ID: 36560503
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
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 36560527
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
 

Author Comment

by:JackJackson54
ID: 36560583
My,  I had never used the Fixed.  Thanks as I have been struggling with this for a month.

0
 
LVL 61

Expert Comment

by:mbizup
ID: 36560632
Glad to help out :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question