I’m confused

Currency Symbol displays in EDIT Field - error when saving

When you set a field to format currency(c) it displays as currency - perfect.
In the DB the field is set to Decimal.
Now when you want to edit the form/grid all the values still have the currency symbol attached.
then when you try and save it gives the error "number is expected" which is coorect if it is trying to save the currency symbol as well.
But if you only want to change the value of one field then you have to take the symbol out of all the rest of the fields with currency formatting.
Is there an easy way to get around this - ie maybe in edit mode the currency symbol does not display?
1 person has
this question