testing for empty Access memo field

RDEdwards · November 1st, 2004, 03:43 PM

How should I write a test for Access memo field to see if it is empty?
I have tried:

IF(Recordset1.Fields.Item("duty2").Value)<>" " then
Response.write"2. "& (Recordset1.Fields.Item("duty2").Value)& "<br>"
else
response.write"2. Empty"
end if

this way will properly print the numeral indicated if the field is not empty
but will not print the contents of the field. What am I missing?
Thanks
Durwood

happygv · November 1st, 2004, 05:17 PM

Hi Durwood,

You are checking if it has a SPACE, not for EMPTY which is DOUBLE double quotes without space inbetween. It might also have NULL which is nothing but somthing, not EMPTY. So you should be changing your IF to the following one.

Code:

IF Len(Recordset1.Fields.Item("duty2").Value))>0 then
    Response.write "got something in it"
ELSE
    Response.write "EMPTY"
END IF

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

RDEdwards · November 3rd, 2004, 04:17 PM

Actually the problem arose from the fact that an Access memo field can only be retrieved once. Copying the field content to a variable solved the problem.

happygv · November 9th, 2004, 09:03 AM

Quote:

quote:Actually the problem arose from the fact that an Access memo field can only be retrieved once. Copying the field content to a variable solved the problem.

So where does that value go once retrieved from the recordset, does that erase the value from recordset? I am not sure if that can be retrieved only once. I haven't heard about that yet. May be you can use that as the last item in the SELECT list. That should do the trick.

Cheers!

_________________________
- Vijay G
Strive for Perfection