Jun 4, 2003 #1 jass1220 Programmer May 20, 2003 88 AE i want to check if what the user entered in the textBox is 7 digit length before ... how i can now ?
Jun 4, 2003 Thread starter #2 jass1220 Programmer May 20, 2003 88 AE i want to check if what the user entered in the textBox is 7 digit length before i save in the database ..how i can now ? Upvote 0 Downvote
i want to check if what the user entered in the textBox is 7 digit length before i save in the database ..how i can now ?
Jun 4, 2003 1 #3 PS42 Technical User Jun 4, 2003 52 AU Hi jass1220 i) Set the MaxLength property on the text box to 7 characters. - or - ii) Use the Len command as follows: Private Sub Text1_Validate(Cancel As Boolean) If Len(Text1.Text) > 7 Then Cancel = True End If End Sub Hope this helps David Upvote 0 Downvote
Hi jass1220 i) Set the MaxLength property on the text box to 7 characters. - or - ii) Use the Len command as follows: Private Sub Text1_Validate(Cancel As Boolean) If Len(Text1.Text) > 7 Then Cancel = True End If End Sub Hope this helps David
Jun 4, 2003 Thread starter #4 jass1220 Programmer May 20, 2003 88 AE thanks alot .. this what i needed If Len(Text1.Text) < 7 Then Upvote 0 Downvote