NULL fields and numbers

[Geoff Gunson]

To get round the "invalid use of NULL" you can use var = "" & rs!field_name, but how do I do the equivilant with numbers? I have tried:

If rs!field_name <> Null Then

but the code never enters the "if" satement.

I don't really want to set the data to 0 either.

Thanks

Geoff

------------------

[Maxi]

Try with:

If Not IsNull(rs!field_name) Then ...

Maxi