Change formatting of a Control in Report Based on Boolean

[dmax17]

Hello,

I would like to change the text formatting (color, italics, bold etc) of the contents of a control based on a boolean value in the underlying datasource of the report.

For instance, I have a report that generates a "Proforma Invoice" i would like to ability italicize the prices of certain items based based on a boolean value (EstimatedPrice) in the underlying datasource.

Please help.

Thanks
DM

 

[dmax17]

Got It !! Using Expressions in Conditional formatting ..

 

[Ranman256]

make them virtual fields in the query.

iif([Estimated],"""","") as Quotes