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?
LVL 3
maharlikaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

omgangIT ManagerCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
maharlika,

<You can define a custom display format exactly as you wish>
Yes!
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!
:)

JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.