Empty DB field causing grief!!

[Davadvice]

you could try

if len(rsMyRS![field3])=0 then

I normaly use rsMyRS(2) instead of having to type out the field names all the time. I find it easier to use as i can create a query and then add the fields in to excel and return the index by numbering each column.

cheers

David