how do i preceed a number with '$' sign automatically

S

sam

how do i preceed a number with '$' sign automatically for a fields that
inputs dollar amount.

Thanks in advance
 
J

John W. Vinson

how do i preceed a number with '$' sign automatically for a fields that
inputs dollar amount.

Thanks in advance
Click to expand...

You don't, in a *field*. Fields store data (numbers in this case).

You can do so in a *control* such as a textbox on a Form or Report, by setting
the textbox's Format property to "Currency" or to "$#,##0.00".
 
Top