Checking for No Value

[dungstar]

I need to be able to check whether or not a value is assigned to a certain field. How do I do this?

For some records, some fields contain no value. I need to detect when that field contains a value and make a label visible. (This is for the report's detail section.)

I tried several things, none of which works because I get an error saying that the field I'm trying to check contains no value.


Private Sub Report_Open(Cancel As Integer)
If Not IsNull(Me.Field1) Then
Label1.Visible = True
Else
Label1.Visible = False
End If
End Sub

Please help! Thanks!

 

[Rich]

Use the on format event
Me.Label1.Visible= Not IsNull(Me.Field1)

 

[dungstar]

It works in the Detail Format section. Thanks, Rich!