underlining in formula

[hyuan]

Is there any way to underline a portion of text in a formula?

e.g.
if (data.transaction_validated = 1) then
"This " + {data.transactions_type} + " is approved. " + ...
else
"This " + {data.transaction_type} + " requires approval. " + ...

where just the words "requires approval" is underlined.

Thanks in advance for any suggestion,

Howard

 

[BradW]

Hyuan,

Depending on which version of Crystal you are using you can do this, but not in the formula you are looking at.

You need to format the field that contains the formula (right click on the formula on the report and then choose the Format command from the pop-up menu).

On the field format menu, you will see a tab for Font. On the font tab, there are several options that can take formulas. I have successfully used the ones to change colors or change from normal weight to bold. There is a formula button by the underline checkbox that should be able to do the same thing.

The type of formula I have used before in the Font formula is something like this:

If {Amount_Due} > 1000
Then Red
Else Black

Take care.