Solved

Can't Find IsNothing Function in VBA librarys.

Posted on 1998-03-31
1
1,397 Views
Last Modified: 2012-06-27
If you go to Help and look at the IsObject function, it says you can use the IsNothing function.  However, it doesn't appear to exist in Access 97!!!!  I'm trying to use an If..then statement to determine if a variable defined as "Form" has been assigned the Nothing value.  It would be nice if I could use the IsNothing function.  

p.s. I have two questions for the designers of this web site:
1.  Why don't you have a search capability so we can search all questions and answers?
2.  Why do we have to determine how hard a question is?  That's pretty relative, don't you think?  The hardness of a question depends upon the answerer, not the questioner.  Shouldn't the experts determine how many points to deduct from our "banks"?
0
Comment
Question by:IRProgrammer
1 Comment
 
LVL 17

Accepted Solution

by:
ramrom earned 100 total points
ID: 1972631
INTERESTING. The help file must be upgemixed. Try this:

Function IsNothing(x)
  IsNothing = TypeName(x) = "Nothing"
End Function

RE PS
1-the site designers normally don't read the postings. There is a Customer Service Area with a Suggestions topic where you can communicate with them. See the home page.
2-If your question is too low in points we will ask you to raise the point value. Its all relative.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Print focus keeps focusing to the caller form 3 25
View vs Edit mode enhancements 12 40
Direct Mail software 4 42
ms/access hyperlink/ftp 7 31
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now