Conditional Underlining in a report

D

Don

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.
 
F

Fons Ponsioen

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
 
Top