Preventing spaces and tab characters

[SkyHigh]

Hi

How do I restrict user from typing space and tab character in textbox for inputting password.

Thanks

 

[Gwena]

You can always use the instr() after the user submitted the password

 

[Eurt]

Private Sub Command1_Click()
If InStr(1, Text1.Text, " ") <> 0 Then
MsgBox ("No spaces please")
End If
End Sub

 

[DrJavaJoe]

Lot's of threads on this here's one of many thread222-608927

&quot;Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.&quot;

 

[nick11]

In fact, it seems to me it may be better to put checking code into the KeyPress() subroutine of the textbox into which the user is typing the password:

Private Sub txtPassword_KeyPress(KeyAscii As Integer)
If KeyAscii = Asc(" ") Or KeyAscii = vbTab Then
' Remove the keystroke, so the text box never sees it.
KeyAscii = 0
End If
End Sub