How to stop "Invalid use of Null: 'Split'"

[cyprus106]

Here's the code I've got. When I try to execute this code with nothing in rsUsers("Proposals&quot, it gives me a:
"Invalid use of Null: 'Split'" error...

if Trim(rsUsers(&quot;Proposals&quot) <> nothing then

Dim arrUser
arrUser = Split(rsUsers(&quot;Proposals&quot, &quot;, &quot

end if



Cyprus

 

[clarkin]

Two options: check for null with the ISNULL() function, or compare to an empty string &quot;&quot;.

if Not IsNull(Trim(rsUsers("Proposals"))) Then..
-or-
if Trim(rsUsers(&quot;Proposals&quot;)) <> &quot;&quot; Then..

Try both

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].