I'm no VBA guru, but I'm trying to use the code below to change the appearance of a field to bold red if the condition is met. It changes the font color to red just fine, but does not bold it. Nor does it give me any kind of error. Can someone please tell me what I'm doing wrong?
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
If Avg1 >= 3 Then
Avg1.ForeColor = vbRed
Avg1.FontWeight = vbBold
End If
End Sub
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
If Avg1 >= 3 Then
Avg1.ForeColor = vbRed
Avg1.FontWeight = vbBold
End If
End Sub