Hello! We run our business from a Filemaker Pro 8 database we designed and built ourselves. It works very well for our purposes, and has been highly customized to make our lives easy (this is the truly magical benefit of FileMaker Pro).

However, one aggrivating issue we haven't been able to resolve involves getting text that we paste into fields in our database (usually from a website) to conform to the size, color and font we use for the rest of the database. We've checked through the text formatting options for all of the fields, and eventhough they're all the same, when we paste text in, it maintains the color and formatting of the webpage we copied it from. The user then has to select the contents of the field, and change the color, size and sometimes the font back to the defaults. It's a big waste of time, not to mention, it looks ugly when somebody forgets to do it.

Can anybody think of an easy solution for this? Many thanks in advance for your replies.

Jason

Welcome Jason,

FM7/8 does retain the style of pasted text unless your users use the option to paste without style (hold down the option key when pasting.) But you can also specify an auto-enter calc on those fields to remove the formatting automatically.

In version 7, use this auto-enter calc:

Evaluate ( Quote ( Field ) )

In version 8, you can use:

TextFormatRemove ( Field )

Be sure to deselect the option "Do not replace existing value of field..."

Ha!!! Success! Thanks a billion! I'm stoked!

Hi -

I'm having the same problem Jason was, but when I try to do what you suggested, it doesn't work. Any idea as to why?

thanks,

Noam

Welcome Jason,

FM7/8 does retain the style of pasted text unless your users use the option to paste without style (hold down the option key when pasting.) But you can also specify an auto-enter calc on those fields to remove the formatting automatically.

In version 7, use this auto-enter calc:

Evaluate ( Quote ( Field ) )

In version 8, you can use:

TextFormatRemove ( Field )

Be sure to deselect the option "Do not replace existing value of field..."

Checklist:

1) Your field is an Auto Enter Field

2) You have deselected the option "Do not replace existing value of field..."

3) The field you are referencing in Evaluate ( Quote ( Field ) ) is your auto enter field.