I recently moved from FileMaker Pro v5.5 to v9 when I got a new iMac and OS 10.5.

In my dB's I had a SetField script that I used after I pasted text into fields from various sources, and the script would set the formatting of that text to whatever the field format was, rather than the formatting of the pasted text.

In v9, the script doesn't do anything and I can't find anything in the Help file on the SetField function.

This was the content of my script:

Set Field (database::Field,database::Field)

I had one line in the script for each field that I wanted the script to set.

How do I accomplish this in v9?

In version 7 and above, Set Field[] works with styled text, so setting a field to itself no longer removes the styling. Either one of the following should do it:

Set Field [ Table::Field ; TextFormatRemove ( Table::Field ) ]

Set Field [ Table::Field ; SerialIncrement ( Table::Field ; 0 ) ]

Set Field [ Table::Field ; Evaluate ( Quote ( Table::Field ) ) ]

Undo/Redo [ Undo ]

# if called immediately after paste

You can also remove the styling manually, either by holding the Option key while pasting, or by selecting Undo immediately after pasting.

Edited April 30, 200817 yr by Guest
added more

Worked fine, Many thanks