How to preserve field format when pasting text?

[John McDaniel]

When pasting text into a FM field from the Finder (as in copying a filename) or when pasting text from another application (Text Edit, for instance), the FileMaker field takes the text and maintains the format of the text as it was formatted in the source document. Is there any way to prevent this?

Can you set a field to take any text pasting and convert it to the format settings for that field?

Thanks for any help (using FM 5.5 BTW).

John McDaniel

[Lee Smith]

Paste without style.

On a Mac it is the key combination of Cmd Option V

HTH

Lee

[John McDaniel]

True.

Well... count me as one who thinks there should be a "conform data pasted from external source to field format" option for text fields. Just trying to make things as simple as possible for a database user.

Thanks, j mcd

[Lee Smith]

You can workaround this problem in a couple of ways.

1. Create a script that replaces the field with itself

2. You can always hide the field once it has been pasted into, by stacking a calculation field that equals it on top of it.

For an example of this, see my file Phone Number Entry that I attached to this thread (Layout Stacked) Click Here

HTH

Lee