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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.