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

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top