Format based on Formula result 1

[Pete271]

Hi

I'm using CR8.5 and an Access Database.

I have the following formula

if {CnPrProp_1.CnPrProp_1_Amount_Asked}=$0.00 then {CnPrProp_1.CnPrProp_1_Source}
else totext({CnPrProp_1.CnPrProp_1_Amount_Asked}, 0)

what i would like is if the forumla returns the 'Amount Asked' for the field to be in bold. But I can work out what to put in the X+2 box in format field

Thanks
Peter

 

[bdreed35]

Right click the field, and choose Format Field.
Under the Format tab, click the X+2 button to the right of Style.
In the editor, add the following logic:

if {CnPrProp_1.CnPrProp_1_Amount_Asked}<>0
then 1
else 0

Save, Close, and Test.

The decode is as follows:
0 - Regular
1 - Bold
2 - Italic
3 - Bold Italic

~Brian

 

[Pete271]

Brilliant.

Many thanks
Peter