How do your remove formatting when pasting, then allow it?

Discussion created by WBullard on Feb 4, 2013
Latest reply on Feb 5, 2013 by taylorsharpe

I want to remove formatting when people past data into a field, but then allow them to later fomat it in that same field.


When I use a calc in the database field options such as RemoveTextFomat(self) and uncheck the "Do not replace existing value of field (if any)", then paste data into a field, the formatting does get removed. Good. The bad news is that I can't format the data in this field after the intial paste.


When I check the "Do not replace existing value of field (if any)" and paste formatted text, the formatting is not removed even when the field is empty when I paste the formatted data. I was hoping it would remove the formating since it was not replacing any existing value, then allow formatting.


What am I doing wrong?