Null criteria in Access 2007 1

[MICKI0220]

I have a form that looks for whether a job is active or not...some people type in "y", "N" or nothing at all. I need a message to pop up if the job is "N" or blank. My code runs fine with "Y", "N" but does not work for blank entries....this is my code, can someone please tell me what to put in to find the null values. I have tried, " ", isnull and null.

Dim varactive As Variant

varactive = DLookup("[Active Job]", "tbl Subcontractor Schedule", ("[jobno] = [Combo5]"))
If varactive = " " Or varactive = "N" Then
MsgBox "This is not an Active Job"
Else
End If


thank you,
Micki

 

[MajP]

if trim(varActive & " ") = "" or varActive = "N"

accounts for both null, "" or "

 

[GingerR]

if len(Trim(varActive)) = 0

OR

if not varActive = "Y" then

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[MICKI0220]

Thanks all both of you, I forgot to let you know that I tried MAJP's code and it worked fine.

Micki