how can I validate if a variable is set in my code?

set olApp = ....

How can i check that this line ran properly and actually set the variable?

IsNull, IsEmpty,Ismissing,... what should I use in this case?

QB

IsEmpty(), I believe.

IsMissing is only for arguments and I'm pretty sure IsNull doesn't work in
this case


--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain


"Question Boy" wrote:

> how can I validate if a variable is set in my code?
>
> set olApp = ....
>
> How can i check that this line ran properly and actually set the variable?
>
> IsNull, IsEmpty,Ismissing,... what should I use in this case?
>
> QB

On Thu, 26 Feb 2009 11:47:02 -0800, Question Boy
<(E-Mail Removed)> wrote:

>how can I validate if a variable is set in my code?
>
>set olApp = ....
>
>How can i check that this line ran properly and actually set the variable?
>
>IsNull, IsEmpty,Ismissing,... what should I use in this case?
>
>QB

Try

Is Nothing
--

John W. Vinson [MVP]

Question Boy wrote:

>how can I validate if a variable is set in my code?
>
>set olApp = ....
>
>How can i check that this line ran properly and actually set the variable?
>
>IsNull, IsEmpty,Ismissing,... what should I use in this case?


Try:
olApp Is Nothing

--
Marsh
MVP [MS Access]