Forum Discussion

MichaelB200's avatar
MichaelB200
Copper Contributor
Oct 01, 2024

Validating that data was entered into a text Box

I have a Signin form (frmSignIn) with two Text Boxes asking for a UserName (txtName) and Password (txtPassword).  The form also has two command buttons Enter (cmdEnter) and Add User (cmdAddUser).   ...
2016
access
Ken_Sheridan's avatar
Ken_Sheridan
Brass Contributor
Oct 01, 2024

Make the operational code in the buttons' Click event procedures conditional on neither text box control being Null or containing a zero-length string, e.g.

 

Private Sub cmdEnter_Click()

 

    Const MESSAGE_TEXT  = "Both a valid user name and password must be entered."

 

    If Nz(Me.txtName,"") = "" Or Nz(Me.txtPassword,"") = "" Then

        MsgBox MESSAGE_TEXT, vbExclamation, "Invalid Operation"

    Else

        ' operational code goes here

    End If

 

End Sub

 

Private Sub cmdAddUser_Click()

 

    Const MESSAGE_TEXT  = "Both a valid user name and password must be entered."

 

    If Nz(Me.txtName,"") = "" Or Nz(Me.txtPassword,"") = "" Then

        MsgBox MESSAGE_TEXT, vbExclamation, "Invalid Operation"

    Else

        ' operational code goes here

    End If

 

End Sub

Resources