getting rid of $ in currency datatype

[linger]

hi there,

how do you get rid of the $ sign in the control box when you use the currency datatype?

yiling

 

[SydneyGeek]

Have you tried using a custom format in the Format line? Something like...

#,##0.00;[Red](#,##0.00)

That will give you 2 decimal places, a thousands separator, no currency symbol, and negative values will be red and in parentheses.

You'll need to go into the Properties of the control (presumably on a form), select the Format tab, and place the above notation in the Format line

HTH

Denis

 

[linger]

thanks... that expression in the format did the trick for the form.

how about the table? i tried converting the currency to decimal type but the table would not save. it said i had too many field entries even though i only had 4 entries. my original table has abut a hundred entries. is there any other way to save my data input into the table without using currency?

ling

 

[SydneyGeek]

If the numbers are financial, Currency is the way to go. By default that is a decimal data type; Long, Single and Double are binary and may cause you problems (unless you need to go over 1,000,000,000,000,000 :wink: )

If you create the same custom format for the field in the table, it shoudl work fine.

Regards

Denis

 

[linger]

Thank YOU!!!! You're a life saver. Those $ signs were driving me crazy!! What would I do without someone like you?

yiling