Disable Spaces

[mr moe]

Hi, I have a text box in a from for data entry, how do I disable a space. For example I don't want the user to have a space between charaters or before and after a charater. Thanks.

 

[boblarson]

In the text box's KEY PRESS event put this:

If KeyAscii = 32 Then KeyAscii = 0

 

[KeithG]

open form1 in the exampe and try to input a name with a space

 

[boblarson]

open form1 in the exampe and try to input a name with a space

Not real beneficial as it lets you type a space, or spaces, and then lets you know AFTER the fact. My code will keep you from typing a space at all.

 

[KeithG]

Yeah your way is better. Just Rub it in BOB!

 

[boblarson]

Yeah your way is better. Just Rub it in BOB!

Gotta take 'em while I can get 'em Keith. You are leaving me fewer things to correct and I'm starting to feel not needed

 

[mr moe]

In the text box's KEY PRESS event put this:

If KeyAscii = 32 Then KeyAscii = 0

Thanks Great Advice. This worked very good.

 

[boblarson]

Happy to help!

Glad that we could help.