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!

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

How to specify that variable Null

Status
Not open for further replies.

miho1

Technical User
Oct 22, 2002
78
BG


Hi all,

At me the following code:

If DataEnvironment1.rsCommand19 ("Time" = Null") Then

In a case when cost " DataEnvironment1.rsCommand19 (" Time ")"
Really Noll, does not carry out construction below.
Someone knows as to specify it?

Miho

 
If IsNull(DataEnvironment1.rsCommand19) Then
'Do something
End If

Good Luck!

Have a great day!

j2consulting@yahoo.com
 
Big gratitude SBendBuckeye.
You have rescued me.

Miho
 
you can also use VarType() with vbNull; VarType also works for Empty and Error
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top