Changing font in detail line

[tmorrison]

Is it possible to change the font of output fields in the detail section based on the value of one of the fields to be printed? Some lines bold, some not bold, some italicized based on a value in a field..?

 

[PaulBricker]

Yes. I do this for a report that tracks electricity charges for our buildings. If any building is more that x% of the total it shows up in bold. In the Format event for the Section the info is in (usually the Detail section) you would put
If Me.TextboxName > SomeValue Then
Me.Textbox1.FontWeight = 800
Me.Textbox2.FontWeight = 800
.
.
Me.Textboxn.FontWeight = 800
Else
Me.Textbox1.FontWeight = 400
Me.Textbox2.FontWeight = 400
.
.
Me.Textboxn.FontWeight = 400
End If

That should get you close.

Paul

 

[tmorrison]

Thanks Paul.