Removing formatting when entering data

[rcacciato]

I've had a problem with formatting being entered into fields when I paste content. So if I have a field whose formatting is defined on the layout as Verdana 12 but I paste something that had other formatting like Times 24, the other formatting (Times 24) remains in the field.

After some searching, I found that if I set a field to a calculated value of

TextFormatRemove ( Self )

and uncheck the "Do not replace existing content of field (if any)" box, the formatting is removed when I exit the field and the formatting I defined for the field applies.

Is there any way to set this globally for the FM database or for the layout so I don't have to do this for each field? Thanks in advance.

[comment]

You could use a custom menu to replace the Paste command with Paste Text Only or with the Paste script step with the Paste without style option.

 

[rcacciato]

Thanks. So there's no way to set this globally?

[comment]

1 hour ago, rcacciato said:

So there's no way to set this globally?

If by "this" you mean auto-entered correction of user entry, then no - I don't know of a way to set this for all fields at once.

Another option you could consider is a script triggered on record commit that loops among all fields on the layout (more precisely, all fields in the layout's tab order). But IMHO attacking the problem at its source would be best.

 

[comment]

By sheer coincidence I came across the following article which explores several methods to deal with this problem:
https://luminfire.com/2016/08/19/filemakers-paste-command/