You could also use <br>
<br>
Dim amount As Single<br>
amount = val(me!text1)<br>
Text1.Text = Format(amount, "$ ###,###,###0.00")<br>
<br>
This would place the dollar sign, then a space before your ammount.<br>
<br>
The # are used only if there is a nuber to place there.<br>
The 0 are...