Invalid use of Null Error
Posted on 2006-03-27
In my cmdOk, when users type in their Username, they are expected to type in their password as well. Bu if the User enter's his name and failed to enter his password, he gets the error message below:
If IsNull(Me.txtUser) Or IsNull(Me.txtPassword) Then
MsgBox "You left the User Name and/or Password blank." & Chr(13) & "Please enter the correct User Name and Password or " & Chr(13) & "contact the Database Adminstrator for assistance.", vbOKOnly + vbCritical, "Logon Denied"
However, when the msgbox above appears, another error message occur on top of that:
"Invalid use of Null"
How do I eliminate this error: "Invalid use of Null" from showing ?.