is not so necessary use currency sign in the field…
U can create a New TextField class
Create a new class
name : CurrencyField
super : TextField
Press right mouse button ( or equal in mac os ) on the new TextField Class and select 'Add to ‘CurrencyField’ and select ‘Shared Computed Propery’ named the new property with ‘Currencyvalue’
in Set Method add this code :
me.text = Format(value, "\\$-#,###,###,###.00")
in Get Methos add this code :
return replace(me.text,"§","").CDbl
Now insert in your project this new CurrencyField and please, use “Currency” type for variable currency NOT DOUBLE cause double value leave a scrapt in calc ( eg: discount or vat etc… ).
For use in code, U have put a new contror CurrencyField named field1
for assign a value use :