I have a field option calculation on a F Name Field that strips out formating and adds title case.

TextStyleAdd (TextStyleAdd ( F Name ;Plain) ; Titlecase )

(Do not replace - is not selected)

Works great! Except when I do an email merge all the title case formating is lost.

Many times the information in the field is placed there by a script parsing a web page. Would I be better off formating it within the set script on entry?

Also assigning a field on a layout to be bold that contains the F Name field will not show in bold. Even if this is a field that joins the F Name and L Name fields.

Edited September 30, 200817 yr by Guest

1. Styling done on the data level overrides layout formatting. If you want to remove styling from entered/pasted text, use the TextFormatRemove() function, instead of forcing the style to Plain.

2. E-mail is always plain text, and any styling you have applied to your data will not be preserved. You could use the Proper() function instead - note, however, that this will modify the actual data, unlike TextStyleAdd ( text ; Titlecase ) that merely styles it (export your data to a plain-text format to see the difference).

Thanks! That helped. I ended up with:

F Name=

Proper(TextSizeRemove (TextColorRemove ( TextStyleRemove ( F Name; AllStyles))))

And ran a looping script to correct the old ones.

Thanks again.

The TextFormatRemove( ) function removes everything - size, colour and style - in one go.