Testing Null

The syntx for assigning and testing for Null values is similar to the way the Empty value/subtype works. Here is some code that assigns a Null value to a variable:

varTest = Null

However, you cannot directly test for the value of Null in the same way that you can with Empty - you must use only the IsNull ( ) function to test for a Null value. This is because Null represents invalid data, and when you try to make a direct comparison using invalid data, the result is always invalid data. Try running the code given on next post.