Remove formatting in a field

[Frank E]

The text formatting in a field needs to be made consistent. For example, I have a field which is formatted in layout mode as Helvetica 10, but entries in this field can be formatted differently in different records, especially if the data is pasted into the field.

In FM 5.5 I was able to make the formatting consistent by using Replace (using a calculated result where the calculation is the name of the field itself) This is from Article 103775 in the Filemaker Knowledge Base. But this doesn’t seem to work in FM 7.

Any suggestions? I need a simple way to make the formatting consistent.

Thanks in advance.

[CyborgSam]

Frank->

FileMaker 7 includes text formatting functions in the calculations, they can be used in the Replace script step.

You could also use the standard trick of overlaying the field with a calculated field that formats the field.

[Ender]

Users can omit the formatting when pasting by holding down the option key. If you want the formatting to always be removed, you can add this auto-enter calc to the field definition (uncheck the 'do not replace existing value' option)

Evaluate(Quote(Field))

To fix existing data in those fields, use that calc in a Replace.

[Frank E]

Thank you. I’m going to try using the Evaluate function.