Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How Do you Determin is an object is set or not

Status
Not open for further replies.
bitmite

bitmite

Programmer
Dec 2, 2003
122
CA
I have an optional object parameter in a funtion I have built.
I tried usinf the ismissing function but it does not work properly.
Is there another way to determin if that object is set when the function is loaded.
 
Sort by date Sort by votes
For an object, test IS Nothing rather than IsMissing as in
[tt]
If myObj IS Nothing Then
' Do Stuff
[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
585
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
922
Kennelbloke
Kennelbloke
I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
693
hermanlaksko
hermanlaksko
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
739
dhookom
dhookom
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
588
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top