ISNULL(expression)

Returns the value True or False depending if the expression contains no data (Boolean).


expressionThe expression to test.

REMARKS
* The Null Value can only be used in conjunction with the Variant data type.
* If "expression" is Null, then True is returned.
* If "expression" contains more than one variable and any of these variables are Null, then True is returned.
* You can use the ISARRAY function to return True or False depending if the value is an array.
* You can use the ISDATE function to return True or False depending if the value is a date.
* You can use the ISERROR function to return True or False depending if the value is an error.
* You can use the ISNUMERIC function to return True or False depending if the value is a number.
* For the Microsoft documentation refer to docs.microsoft.com

IsNull(Null) = True 
IsNull("") = False

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top