null field value and field names vs. variables

[DebbieDavis]

Hello all. I didn't know how to search for this so please forgive me if it's redundant. I'm pulling information from an orders table into a form for review. If some of the fields are empty, I receive the ugly error '80020009' . This particular one errored on a field called rs("ship_to_name") which is null. There are so many fields, do I have to assign variables for them then do an if statement like this:

if rs("ship_to_name")>"" then
ship_to_name=rs("ship_to_name")
else
ship_to_name=""
end if

or is there another way to avoid the error. I would prefer not to use on error resume next. Thoughts greatly appreciated!
thanks in advance.

 

[amorous]

Try this:

if isnull(rs("ship_to_name")) then
ship_to_name=rs("ship_to_name")
else
ship_to_name=""
end if


-VJ

 

[amorous]

sorry...

what i meant is ---No need to assign variables...

just use the condition

isnull(rs("ship_to_name")) to check the records that have ship_to_name empty

-VJ

 

[DebbieDavis]

Thanks. I was trying to avoid all of that. Isn't that basically what I had above? It seems like it's too much to write because I have 30 fields but I guess I'll have to do it anyway. Many thanks again for your response!!