Textbox in Userform

[mikeymay]

I seem to be unable to use the spaces in the contents of a textbox I have in a userform.

Is there some way of allowing this as I can;t seem to find a solution.


TIA

 

[mikerickson]

Its not clear what your problem is.
What do you do, what does the userform do in response and what would you rather it did?

 

[mikeymay]

The textbox is being used to enter some text. If I needed to add 'Item1' (no space), then I can do this but if I want to enter 'Item 1' (one space) it won;t allow it. When I press the space bar it does nothing.

 

[Fluff]

Do you have any code operating on the textbox?

 

[mikeymay]

Sorry!!!

Worked out what the issue is. I am using a TRIM function when the control changes so it's removing the space added very quickly and it looks like it's not allowing the space entry.

 

[mikerickson]

The Trim statement to eliminate double spaces should be in the AfterUpdate event rather than the Change event.