Conditional formatting, expression needed

[rbrule]

Hello,

I would like to bold all fields in a record in my report, if the value of my [commission field] =0. In design view I highlighted all involved fields, and entered the conditional formatting menu. I know that I need to choose "expression is" . However I don't know how to write the expression.

Can someone help me with this?

 

[Graham T]

rbrule

Once you choose Expression Is you just then need to enter the expression as:

[commission field]=0

When you preview the report all selected fields should appear in Bold if the Commission field value = zero.

HTH

Graham

 

[rbrule]

Thank you Graham, I appreciate your help.