Sue,

If you really want to apply multiple formats to a field, simply embed them:

TextStyleAdd (TextStyleAdd (TextSize (TextFont (text, Arial), 10), Plain), Bold)

This will put text in 10 point Arial with Bold-only formatting. However, if you simply want to remove any custom formatting resulting from pasting, you should probably strip out any formatting from the field contents, and apply formatting to the text box in the layout you want formatted. Use:

TextFormatRemove (text)

Set the field "text" to Auto-Enter the above calculation, and uncheck the box that says "Do Not Replace Existing Value".

On Feb 22, 2007, at 1:39 PM, Sue wrote:

I have been interested in the posts here about standardizing formating in fields where folks are pasting in information in various fonts and styles. I decided what I wanted to do was set up a calculation field that takes the text they paste in a field and applies font size, style, color etc. But I have been unable to figure out how to apply size, style, color, and font all in one calculation equation. I can do it with multiple calculations each applying one of these, but this is unwieldy. Can anyone show me an example of a calculation string that applies font, size, color, and style to a field named TEXT.


Thanks!

Sue



Jim Main
-------------------------------------------
619-948-5293
[EMAIL PROTECTED]
-------------------------------------------

Reply via email to