Is Null

[Krash878]

Hello,

I am trying to prompt a user for entry if a field is left null but I cannot get the code to work properly.

here is what I have in the VB part of the form:


If Me.passenter = Null Then
MsgBox "You must enter text"
Else
End If

I am not sure if I am wrong here but this does not work.

Me.passenter is a textbox

Thanks

Kenny

 

[TerpFan2001]

Kenny:

Try If IsNull(Me.Passenter)=True Then...

 

[Krash878]

yes that works.

Thank you


Kenny

 

[Krash878]

I made another post that has to do with this if you want to take a stab at it.


Kenny