[Webinar] Streamline your web hosting managementRegister Today

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

Display all digits, not exponents in Access

In Access 2003 Form, the display for "160,000,0000,000" is "1.6E+11".  How do I get it to display the 000's, not exponentials?
1 Solution
You need to change the display format for the field/control.  A general number format will display large numbers in scientific notation.  Set the display format to Standard and it will display the number in long format but with two zeros after the decimal.  You can define a custom display format exactly as you wish.  Search Access help for 'Format Property'.

OM Gang
Jeffrey CoachmanMIS LiasonCommented:

<You can define a custom display format exactly as you wish>
There a lot of cool formats you can create on your own to make the numbers look the way you want.
For example:
Custom Format      Entry      How it Appears
$#,##0.000,, "M"      1234567      $1.235 M
$#,##0,, "M"      1234567      $1 M
(From John Walkenbach, Excel 2000 Power Programming With VBA)

Have fun!


Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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