Evaluating a blank value 1

[mdr2271]

I am assiging the variable varintdate to a field value from a recordset. I then evaluate it to see if it is blank or contains a value in an if then statement. However, when the value is blank or null it is not being evaluated properly. I have tried:

varintdate = ""
varintdate = null
trim(varintdate) = ""
trim(varintdate) = null

and none of them work.

 

[DotNetGnat]

try this:

if varintdate="" or ISNULL(varintdate) then

-DNG

 

[Sheco]

If you combine a Null with a string, the result is always a string.

So you can do this:[tt]
MyValue = myRs("TheField") [highlight]& ""[/highlight]

If (MyVal = "") Then
'The field was null or empty
Else
'The field had some value
End if[/tt]