Check for Null in Memo Field Wierdness
Posted on 2005-04-20
I am trying to test for a null value in a memo field, and if it is null not print two lines on the web page, but if it is not null print them.
Here is the wierd behavior. On line 40 I have the following
This will print the Line Eligibility, followed by the text in the field Eligibility in the table.
But if I include the following code above line 40
If Len(Trim(objRS("Eligibility"))) = 0 Then
strElig = " "
strElig = objRS("Eligibility")
which just tests for Eligibility being blank or not (I have also tried IsNull(objRs("Eligibility"), then the text for Eligibility does not print on the line below the word Eligibilty. IT IS AS IF CHECKING FOR NULL PREVENTS A NON NULL VALUE TO PRINT.
Any thought, as this is starting to drive me insane.