S sam Jul 1, 2009 #1 how do i preceed a number with '$' sign automatically for a fields that inputs dollar amount. Thanks in advance
how do i preceed a number with '$' sign automatically for a fields that inputs dollar amount. Thanks in advance
J John W. Vinson Jul 2, 2009 #2 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".
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".
