I have a simple phone book and contact database and I'm always copying text from other sources (email, documents, etc.) and pasting it into my database. The problem is that when I paste the text it pastes in the ame color and style of the original text and not that of the field formatting I set up in FM.

How can I keep this consistent do I don't have different colors and styles all over the place?

Edited June 11, 200718 yr by Guest

See if this thread helps.

Format Style

Make your field be an auto enter that replaces field contents with:

TextFormatRemove(yourField)

... should work, provided that that function actually exists in 8.

Can you please tell me how to do that? I'm not that much of a database designer and find the complexity of this stuff a bit daunting.

This is a problem that can be handled in a couple of ways.

For the data you already have in your file, do a simple Replace.

In the future, you can use the Option Key when pasting your text (Cmd Opt V).

Genx has suggested the best way to handle this though for the future.

Open the Define Fields, select the field you want to keep the text formatted as you have specified, and select the Options button.

Select the Auto Enter tab

Select the Calculated Value

Insert the calculation

TextFormatRemove([color:red]yourField) equals your field you have selected.

Click OK (Twice)

that's it.

HTH

Lee

[color:red]p.s.

This doesn't go back an change the data already in the file, that is why you will want to use a Replace and substitute Function

or a script

Edited June 11, 200718 yr by Guest
p.s.