Pasted text keeps style instead of FM field format. I don't like it

[Robert T]

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, 2007 by Guest

[mr_vodka]

See if this thread helps.

Format Style

[Genx]

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

TextFormatRemove(yourField)

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

[Robert T]

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.

[Lee Smith]

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, 2007 by Guest
p.s.