For such variables, objPtr returns 0. An object can be tested for nothingness with the is nothing construct:. The opposite is possible with not obj is nothing not with obj is not nothing :. Also, the function typeName obj returns the string "Nothing" if obj is nothing. Contents Exit focus mode. Is this page helpful?
Please rate your experience Yes No. Any additional feedback? Important Use the IsNull function to determine whether an expression contains a Null value. Viewed 34k times. Improve this question. Welbog 57k 8 8 gold badges silver badges bronze badges.
May I ask what you are using this function for? If you are indeed trying to find them in a table, why not just put null or "" in the where condition on the query instead of calling a function?
Add a comment. Active Oldest Votes. Improve this answer. I think you should be using IsNull to decide if a value is null.
Community Bot 1 1 1 silver badge. Use a combination of Trim and Len i. What you use depends on the context. Badfish Badfish. Add a comment. QHarr QHarr The if Structure is meant to be like that! I just want to check if the string is Null. I just added them to show the problem that my string is at the same time both null and not null. I landed here looking for an answer to "VBA: How to test if a string is Null" while this answer may not apply to this particular users situation, it does apply to the subject question.
Gregor y Gregor y 1, 11 11 silver badges 19 19 bronze badges. To ensure mutual exclusivity, ask the question only once. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked
0コメント