bold a word in a formula

[jakesmom]

Is there a way to bold a word in a formula
ex: "Test" & Chr (13) &
I want to bold "Test"
Thanks a bunch

 

[lbass]

Try:

"<b>Test</b>" + chr(13)

You would then right click on the formula->format field->paragraph formatting->text interpretation->HTML Text. HTML text is larger, so you might want to add a font size tag also, as in:

"<font size = 3><b>Test</b></font size>" + chr(13)

-LB

 

[jakesmom]

Hi, thanks for the response - but that doesnt work.. I failed to mention that this formula is used in a cross tab..
I am creating Fake Title and need to have text next to column summaries.. (Its an Income Statment report)

what does work is "Test" & Chr (13)
you would think it would be simple just to add the html tag?? :-(

 

[jakesmom]

have you ever used crBold??

 

[lbass]

Sure, but I thought the formula contained other text that you didn't want bold. Please explain how you are creating the fake title. Are you adding a higher order column field?

-LB