Check if textbox is empty

[James.uk]

Here's another simple one for you all; I need to check if a text box is empty and pop up a message if it is.

I have tried:

personID = Forms!Add!personID
    If personID Is Nothing Then
        MsgBox ("You must enter an ID number")
    Else...

and

personID = Forms!Add!personID
    If personID="" Then
        MsgBox ("You must enter an ID number")
    Else...

but neither work.

Any ideas?

Thanks again

 

[TessB]

If [personID] Is Null or [personID] like ""

 

[James.uk]

hmm... didn't work.

The null method spawned an error, and the like method just went to the else bit of the statement.

I'm not having a very good day with Access am I?

 

[ghudson]

If IsNull([YourTextBoxName]) or [YourTextBoxName] = "" Then
     MsgBox "Your text box is empty"
Else
     MsgBox "Your text box is not empty"
End If

The OR above will cover you in case they key something in the text box then delete it since the text box will no longer be Null. Also, do not use the name of the field, use the name of the text box object.

HTH

 

[TessB]

What is the error that was generated?
What if you stored the person ID in a variable?

Dim intID as integer
intID = [personID]
if Nz(intID, 0) = 0 then
show your message box

 

[James.uk]

ghudson's worked... thanks a lot