I have a field storing text. I have the field formatted for Times 9 point. Alot of times I get text from a Word document by selecting all and copying it, go to Filemaker Pro 5 and paste it into my text field. When I do this the text pasted is formatted with the font and size of the Word document. My Filemaker field won't force the text format and the pasted text. Then when I print to text from FMP I don't get it all because it's to large.

How can I incorporate an automatic format text script into my print script in FMP? Can this be done or do I have to format all of my pasted text manually?

Thanks for any help.

The Replace command should do the job. You can do this either manually or within a script.

Do perform manually, click into the field you want to correct the formatting for. Choose Replace from the Records menu. Select "Replace with calculated result" and set it to replace the contents of the field with itself.

If you do it within a script, the field must be on the current layout when the script is run.

Replace [ No dialog, "text_field", "text_field" ]

Chuck