Problem with "NULL" 1

[TeddB]

I have the following code:
strVar1 = Forms![frmQry_CaseSummary]![DevlName].Value

If strVar1 = Null Then
..you know the rest...

Debug shows that strVar1 = NULL, however the IF statement does not execute!

What am I not seeing here???

"A good man knows his limitations." -- "Dirty Harry" Callahan (Clint Eastwood)

 

[ReluctantDataGuy]

Try this instead:

If IsNull(strVar1) Then

If that doesn't work, try

If strVar1 = "" Then

 

[don2241]

Hi!

You can also try:

if(strVar1 <> &quot;&quotthen
....
else
....
end if

M.

 

[TeddB]

I tried &quot;If IsNull(strVar1)&quot; and it worked just fine.

Thank you, ReluctantDataGuy.



&quot;A good man knows his limitations.&quot; -- &quot;Dirty Harry&quot; Callahan (Clint Eastwood)

 

[DonQuichote]

Also look in the help for the

Nz

function. It is specially made for variant-to-string conversions.

Best regards