Empty |
Used to indicate an uninitialized variable value. When a variable is first created or its value is explicitly set to empty, the variable is uninitialized and has not been assigned a value. Example: <br> Dim x <br> 'Variable x is uninitialized!<br> x="ff" 'Variable x is no longer uninitialized<br> x=Empty 'Variable x is uninitialized! Note: This is different from Null!! |
IsEmpty |
Used to test whether a variable is uninitialized. Example: If (IsEmpty(x)) 'Is variable x uninitialized? |
Nothing |
Used to indicate an uninitialized object value, or to dissociate an object variable from the object to release system resources. Example: <br> Set myObject=Nothing |
Is Nothing |
Used to test whether a value is an uninitialized object. Example: If (myObject Is Nothing) 'Is it not set? Note: If you compare a value to Nothing, you will not get the correct result! Example: If (myObject = Nothing) 'Always false! |
Null |
Used to indicate that a variable does not contain valid data. Null sets the value to "invalid," whereas Empty indicates the value is "not set." Note: This is different from Empty or Nothing!! Example: x=Null 'x does not contain valid data |
IsNull |
Used to test whether a value contains invalid data. Example: if (IsNull(x)) 'Is x invalid? |
True |
Used to indicate that a Boolean condition is true (True is -1) |
False |
Used to indicate that a Boolean condition is false (False is 0) |