Differences between if(IsNull([field])) and If([field]=Null())

[DavideT]

I tried in a script doing If([field]=Null()) and it doesn't work, while if(IsNull([field])) does. Could you explain to me why?

[BrunPierre · Accepted solution]

Hi,

IsNul() returns a logical answer in True or False (-1 or 0 ), whereas the Null() function returns ‘-‘ in place of a null value.