Check if field is blank

[GiantDaddY]

Can someone please tell me way this works :

if (asc(rsSVPAVP("spbijz")) <> 32) then

and this does not :

if (rsSVPAVP("spbijz") <> " ") then

???????????????????????????????????

 

[dtqbterror]

There Is A Possibility That There Are Spaces Not Being Accounted For In The Field So Instead Of It Containing Only 1 Space It May Contain 2 or More. My Preference For Checking For Something Like This Is.

If (Len(Trim(rsSVPAVP("spbijz"))) = 0 Then
' Do Something Here
End If

http://www.chiefscoalition.com

 

[GiantDaddY]

When I displayed the value of the field between 2 characters I could only see 1 blank.

But your code works and is better than checking with the asc function and the 32 value, so I adopted it in my script, tnx !

 

[dtqbterror]

No Problem Glad To Help

http://www.chiefscoalition.com

 

[dtqbterror]

No Problem Glad To Help.

http://www.chiefscoalition.com