Hi. I'm stepping through a record set from a database, such as in the following code:
Code:
 oRS.MoveFirst
 Do while NOT oRS.eof
  Dim fx as string
  fx = oRS("FaxNumber")
  oRS.MoveNext
 Loop
 oRS.Close
But in my database some of the faxnumber fields are empty. This is causing the following error:

"Runtime error 94: Invalid use of null"

I tried putting an if statement like
Code:
 if oRS("FaxNumber") is NOT NULL then..
but that didn't work, for the same reasons...

I don't know enough about VB to know how to handle this... seems this worked fine when I did it in ASP...

tx
d8