textbox control

[354688]

Hi

I have a textbox on my form that I would like to restrict spaces from being entered and force characters inputted to be uppercase. Data entered can vary so can't really see an input mask working here.

 

[TheAceMan1]

How are ya 54688 . . .

Try the following in the [blue]On Key Press[/blue] event of the control:

[blue]   If KeyAscii > 96 And KeyAscii < 123 Then
      KeyAscii = (KeyAscii And 223)
   ElseIf KeyAscii = 32 Then
      KeyAscii = 0
   End If[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[354688]

Brillant. Thank you very much. You have saved me hours trying to work this out by my selft.