Parts of formula in bold 2

[paulosinuk]

To anyone who can help.

I have a formula that is using two variables to structure a sentence. For ease of reading I wanted to display the variables within the sentence in bold but the rest of the sentence in normal.

Variable A could be "Unlimited", "Group" or "Individual"
Variable B could be "By Licence" or "By Application"

The formula would read:

"This is a " + totext(variable A) + " licence. The licence has been defined utilising the '" + totext(variable B) + "' licensing rule."

Basically the sentence is for the layman but the expert user is just going to want to skim read the sentence and pick out the rules, hence the question 'can parts of a formula be in bold?'

 

[dtaylor92]

Yes, you certainly can. If you create a text object and then insert the formula field, you will have been able to create your sentence. Next, choose "edit text object" and the highlight the formula you want to make bold.

If you right-click you will see the option "Edit [@varA formula]". The format editor will appear with only two tabs, Paragraph formatting and Font. If you click to Font, you will see where you can create conditional formatting for the text.

I am using CR 8.5.

 

[Ngolem]

you can do that as dtaylor92 described....but don't get carried away with this...stuffing formulas and db fields into text fields is not so good for performance...

 

[idle]

Create a formula field that contains your text. Use HTML formatting tags, as in

&quot;This is a &quot; + &quot;<strong>&quot; + totext(variable A) + &quot;</strong>&quot; + &quot; licence. The licence has been defined utilising the &quot; + &quot;<strong>&quot; + totext(variable B) + &quot;</strong>&quot; + &quot; licensing rule.&quot;

Place the formula field, right click, select Format Field, Paragraph Formatting tab, Text Interpretation, pick HTML Text.

I think this only works with version 8 and above. Strong is HTML lingo for bold.

 

[FoxG]

Hi,

It definitely doesn't with CR7

I just tried it!!

Geoff

 

[paulosinuk]

Hi guys,

Your help on this has been brilliant. The only issue I encountered in using Idle's method was that having converted the text to HTML I wasn't able to control the font size. Does anyone have any ideas how to do this becuase I really want to be able to use Idle's methods but the boss doesn't like the way it looks.

Will the management ever be happy?

Cheers

Paulos