Conditional formating in Access 97 report 1

[bmldev]

When I print a report, I want to have a customers name formated bold on condition. The condition is in my table, "customers" ; if a YES/NO field in my customers record is yes, I want that customer's name on the report to be shown in bold print.
Any help is appreciated

 

[mndrlion]

Add the following code to the On Format event of the detail section of your report.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If YesNoField Then
    txtCustomer.FontBold = True
Else
    txtCustomer.FontBold = False
End If
End Sub