Why? As a matter of course, you should avoid Nulls if at all possible. It makes coding easier and you do not have to deal with tri-state logic.

Poor understanding of, and dealing with Nulls causes more problems than anything else. You might be better re-defining the question...

If you really need to do this then you could easily create a recordset and loop through until the field is null using Is Null. You could probably also do this with an agggregate query using First but you ould have to be careful about order in that case and you might need a sub-query.

Cheers,

P.