<div>
maharlika,<br />
<br />
&lt;You can define a custom display format exactly as you wish&gt;<br />
Yes!<br />
There a lot of cool formats you can create on your own to make the numbers look the way you want.<br />
For example:<br />
Custom Format &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Entry &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;How it Appears<br />
$#,##0.000,, &quot;M&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1234567 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$1.235 M<br />
$#,##0,, &quot;M&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1234567 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$1 M<br />
(From John Walkenbach, Excel 2000 Power Programming With VBA)<br />
<br />
Have fun!<br />
:)<br />
<br />
JeffCoachman<br />

</div>


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


<div>
<div class="content wysiwyg-content">
In Access 2003 Form, the display for &quot;160,000,0000,000&quot; is &quot;1.6E+11&quot;. &nbsp;How do I get it to display the 000's, not exponentials?
</div>
</div>


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?

Display all digits, not exponents in Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.