Ok. Here it goes. I have tried everything I can think of.

Form letters database.

Have a text field we will call "LetterBody". Users can enter in text and format text (fonts,size,etc) and also enter in "merge" fields by placing [[clientname]] in body of the letter.

To create the merged letters and to convert [[clientname]] to xyz client name. It uses a calculation field we will call "letterbodymerged" it uses the substitute options to do the merge. Example: (Substitute(Letter Body , "[[clientname]]",Clients::FullName)

The problem is the fact that the new field "letterbodymerged" loses all text formatting (font,size,colors, etc) and defaults to the layouts predefined text formatting.

Is there anyway to do this and save the text formatting the user did?

TIA

With FileMaker by itself, it may not be possible. However, there was a plug-in that I heard about recently appearing that can do this kind of thing. Take a look around http://www.fmplugins.com and see if you can find it in their Interface section.

Chuck

Here's an idea that may or may not be applicable.

Instead of using a calc field for the final product, maybe you could use a script to get the final Client Name for the merge.

If you Cut/Copy from the original point of entry & then Paste, it will paste the format entered in the original field.

Just a thought, I hope it's a little helpful...

Later :-)