Conditional Underlining in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top