1 of 1 people found this helpful
You can set the target field as an Autoenter Calculation...(uncheck the do not replace...)
And then have the calculation be TextFormatRemove(Self)
It won't paste unformatted...but it will remove the formatting once the paste operation is complete.
Change the menu item...
That's a much better way of accomplishing something I tried with a script trigger (and certainly better than nothing). But it has some of the same disadvantages: it needs to be set up for each field individually, it prevents text from ever being formatted (even if desired), and the user sees the formatted text until exiting the field.
I tried replacing Paste with a two-step script, Paste and Commit. That way the user sees unformatted text right away, but it still broke Pasting in non-DB windows, so no good.
FWIW, I have some duplicate fields in one of my solutions...a place where I need the text formatted on one layout, but unformatted on a different layout...two different fields.
User can only access one of the fields (FieldUnformatted).
OnModify for the unformatted, I set the other field to the formatting I want (which may differ from record to record based on other criteria).
That leaves the Dbase (ie. me) in control of formatting...instead of the user.
Users can paste in whatevr they want...I strip the formatting then apply my own through the autoenter and the OnModify script.