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?