On click I want input field to delete the currency formatting

[atrium]

The field format is set to currency eg $0.00) the user moves to the field by clicking on it or users the Tab key.
When the user enters a fugure int the field I want the field to loose the formatting and allow them to put in (eg 2387.09 or 560 and when they leave the field I want it to appear as (eg. $2387.09 or $56.00)

The filed is AmountFld and I have tried

Me.AmountFld.FormatConditions.Delete
Me.AmountFld.SelStart = 0

I cursor starts in the left most position, but I still have the $0.00 and the users get frustrated that they have to delete the formatting before they enter the appropriate figure.

Has anyone any suggestion - anything would help.

Regards

Atrium

 

[arnelgp]

remove any formatting in the table.
instead use a form and set the control's format to currency.

 

[atrium]

Thanks arnelgp will that effect any of the calculations etc

Atrium

 

[arnelgp]

no it will not, the currency format there is for UI (display) only. internally, the data is stored as double.