Conditional Underlining in a report

[Guest]

When I run a report, I want names of people in a particular department to be
underlined leaving the rest not underlined.

The code I wrote, that does not work, is

Private Sub Report_Open(Cancel As Integer)
If Me.DEPARTMENT = 7 Then
Me.NAME.FontUnderline = -1
End If
End Sub

I'd appreciate any help if this is possible. Thanks in advance.

 

[Rick B]

Why use code? Just use the built-in conditional formatting feature.

 

[Guest]

Don. I use the conditional formatting in reports all the time including
underline or baground and or font coloring.
You may want to give conditional formatting a try.
Fons