<div>
or format (number,'#0.00'). Hope this helps
</div>


or format (number,'#0.00'). Hope this helps

<div>
This will give you more ideas<br />
<br />
<a href="http://www.techonthenet.com/access/functions/string/format.php" rel="ugc">http://www.techonthenet.com/access/functions/string/format.php</a>
</div>


This will give you more ideas

http://www.techonthenet.com/access/functions/string/format.php [http://www.techonthenet.com/access/functions/string/format.php]

<div>
<div class="content wysiwyg-content">
Hi. &nbsp;I use in txbox of the report following expression: =Format([Weighted_DSC],&quot;#,<wbr />###.00&quot;)<br />
<br />
If number is &lt;0, Access displays .90<br />
How can I get Access to display 0.90
</div>
</div>


Hi.  I use in txbox of the report following expression: =Format([Weighted_DSC],"#,###.00")

If number is <0, Access displays .90
How can I get Access to display 0.90

format number

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.