How to handle Null values in Access 2000 VBA 1

[vamoose]

I am trying to exit my code if the following value is Null

If Label.Value = Null then Exit Sub
If Label.Value = "" then Exit Sub
If Label.Value = "Null" then Exit Sub
If Label.Value.IsNull then Exit Sub
If IsNull.Label.Value then Exit Sub

None of these seem to work, how are these handled?
Thanks

 

[PHV]

You may try this:
If Trim(Label.Value & "") = "" Then Exit Sub

BTW, you really have an object named Label ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[pwomack]

This may also work:

If Len(Label.Value & vbNullString) = 0 Then Exit Sub