Null Value in Multi Line Fields

Null Value in Multi Line Fields

Am I wrong in assuming that if the multiline field is not updated/altered when a record is submitted, that the field's value is Null?

The reason I ask is that I have some deluge code that executes if a multiline field is not Null.  Something to the effect of:

 
    
  
  1.  if memNote != Null
    2.

Yet the script looks like it is executing if there is no value in the multiline field.  Note: This doesn't happen in every case so it may be that the field originally had a value, and then was deleted.  In that case, is the field EMPTY?

I tried doing some script that would update the multiline field to Null, but received an error saying that you can't make a string null...but they were null to begin with.  Anyway, I updated the code to:

 
    
  
  1.  if memNote != ""
    2.
It seems to work properly now, but only if I update the Null fields to ""

So does a null value exist in a string field or not?

Thanks


Leo Saumure