Handling Null Fields 1

[porto99]

I keep getting the error 'Invalid Use of null object' on the following statement:-

<B>strStatement = rst!STATEMENT</B>

How can I check if this field is null?

Many thanks,

 

[JerryKlmns]

This shall do I think
strStatement = rst!STATEMENT &

 

[jsteph]

The quick and dirty way (it looks like this is an asp page or something?) is to do:
strStatement = trim("" & rst!STATEMENT)

Then check strStatement for "". Again--this is the quick & dirty way. Now, I'm well aware of the significant difference between Null and "", and don't want to start that thread here, but in a general sense, doing the above will avoid that error and give you the easy ability to get the code going.

If your db field makes a distinction between Null and "", then that's a new thread.
--Jim