Bold in one Record

[webjunk]

How can I have one record on the report be bold based on criteria? If I have Rec1, Rec2, Rec3, Rec4 and Rec3 has specific data, I want that whole row to be bold.

Thanks

 

[dhookom]

I would use code in the On Format event of the section containing the controls. To set all of the text boxes in a section to bold if a text box has a value of 1:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ctrl As Control
For Each ctrl In Me.Section(0).Controls
If TypeOf ctrl Is TextBox Then
ctrl.FontBold = Me.txtSomeValue = 1
End If
Next

End Sub


Duane
MS Access MVP