HEllo all,

Should be a straightforward thing;

I have queried a table with field1, 2 and 3.
All fields are not always populated.

So when I allocated variables to, for instance, field3.
I will: field3var = rsMyRS![field3]

Now this will work if the field has got something in it, fair enough. And it the field is empty it will throw an error of :
invalid use of null
again, fair enough.

So to avoid the null error I wanted to put an if loop around like this:

Code:
If rsMyRS![field3] Is Null Then
                    Do something else
End If

But that doesnt work, and I get an Object required 424 error.

I have tried :

Code:
If rsMyRS![field3] is Empty...
And also
Code:
rsMyRS![field3] = ""
No luck.
Any ideas?

THanks

Ramo