Problem with If then else statement

rnutts

Registered User.
Local time
Today, 10:05
Joined
Jun 26, 2007
Messages
110
Hi

Trying to run a report which will look at a field and if a persons name appears in that field the their signature will be visible on the report, if it is not there name then another person signature will appear.
I have put the if statement below on the reports Details section in the On Format event.
Every time I run the report I get the error

You have entered an expression that has no value.

when I run the de-bugger the line with the employee name is highlighted in yellow.

The first part of the code (IsNull) is that sometimes the report can be run with no data to show and I don't want the code to fall over.

Code

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Reports![Certificate Details]![AnalystsName]) Then
Image107.Visible = True
Label105.Visible = True
Label106.Visible = True
Else
If [AnalystsName] = "M McManus" Then
Image107.Visible = True
Label105.Visible = True
Label106.Visible = True
Else
Image109.Visible = True
Label55.Visible = True
Label56.Visible = True
End If
End If
End Sub

any help greatfully received

Richard
 

Users who are viewing this thread

Back
Top Bottom