Help with MsgBox and If Then Statement

[dzirkelb]

I wish to have a msg box pop up to the user if my text box is null, and hten cancel the update...else, have it run as normal. here is my current code:

If Me.txtStoreID = Null Then
MsgBox ("Hey")
Cancel = True

End If

It updates the record if txtStoreID is null, and it isn't popping up a msg box.  If, however, I change it to say, me.txtStoreID=0 and I put store id to 0, then the box works...what am I doing wrong with the null value?  Thanks!

 

[Mile-O]

If IsNull(Me.MyTextBox) Then

 

[dzirkelb]

That did the trick..thanks a ton!

 

[ghudson]

Do not forget about those pesky empty strings. i.e. A user starts typing something in a text box then they use the delete key or backspace key to clear it so that it looks empty but it is no longer Null.

If IsNull([MyTextBox]) or [MyTextBox] = "" Then

 

[WayneRyan]

dz,

If Nz(Me.MyTextBox) = "" Then ...

Wayne