font formatting formula error

[fdgsogc]

I'm trying to conditionally format a field as bolded or not bolded based on the value of the field. The field is a string and this is the code I am using.

"Net Proceeds"

I am entering it but clicking the formula button across from the Style field. My intention is that if the value of the field is "Net Proceeds" then formatting should apply.

I get the following error message.

The formula result must be a number.

Why is it trying to evaluate as a number when the field is a string type?

 

[fdgsogc]

I found a solution but I don't understand why it works. This is the formula I am now entering.

if {rptBingoResults.gr}="Net Cash Proceeds"
then 5

It doesn't matter what number I put after the then statement. I can't find any literature that explains this behaviour.

 

[dgillz]

Font size IS a number, so the result of a conditional format formula for font size must also be a number.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[fdgsogc]

I'm not dealing with font size. I'm dealing with Style (ie bolding).

 

[dgillz]

Try "then crBold"

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?