Have you ever copied text from an application (such as a Web browser) and pasted it into a field in a FileMaker database, only to find that the text was pasted in with the an undesirable style (color, font, size, etc)? Sometimes the styled text is ok. But if you're pasting the text into a field that you use for doing things like printing reports or labels, the styled text can cause you problems.
Removing the style from the pasted text can be very inconvenient. You can do it manually, and start by making the text "plain text" (via the Format / Style / Plain Text menu option). But that doesn't change the font, size, or color of the text. So you have to continue working on the text in order to clean it up.
Another option is to first paste the text into a text editor. (I use TextWranger by Bare Bones Software and highly recommend it!) This removes all of the style and formatting of the text. You then copy the text, and paste it into FileMaker. This is a roundabout way to clean up the text.
Another trick is to paste the text into a container field in the FileMaker database. This will strip out the style and formatting, and leave you with nice, clean, unformatted text. You then copy the container contents (just click on the container and press Command-C), and paste it into the text field. This is very similar to the text editor method that I mentioned earlier, but at least you won't have to use another application to strip the formatting.
Here's the best method I've found for cleaning up the formatted text: When you paste the text into the FileMaker field, immediately press Command-Z. Command-Z is typically used to undo something, and you'd think that doing this after pasting text into a field would undo the paste operation. But that's not what it does in this case. Instead, it leaves the pasted text in the field, but removes the formatting for you! (Note that pressing Command-Z a second time will undo the paste altogether!)
Got a tip or trick that you'd like to share with other FileMaker Addict readers? Are you a FileMaker Addict that is ready for your 15 minutes of fame? Email me and let me know!