Solved

Can't Find IsNothing Function in VBA librarys.

Posted on 1998-03-31
1
1,405 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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 …

738 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