Checking A Value In Access DB
i have a field in MS access that doesn't have a value and the properties of the field are set as follows:
Type: Text
Required: No
Allow Zero Length: No
Indexed: No
Unicode Comprerssion: Yes
okay . . .
i'm trying to run a check against this field's value but it's not working. here's what i did:
If Not Len(myField)>0 Then
sEE="RIGHT"
Else
sEE="WRONG"
End If
I've tried every case for my If statement to do the eval and i always get "WRONG". i've used all of the following checks:
If Len(Trim(myField))<0 Then
If myField="" Then
If myField=" " Then
If myField=null Then
I've even tried to write out the value of the Len function and it give me nothing: Response.Write(Len(myField))
any ideas of why nothing's being returned?
i know it's not the db because i've checked the spelling, the connection, and all that.
|
