empty space start combo

[sergran]

I'm sorry, I did not realize that now is not copied the words that appear in the text box "words" in the text box "review track 01"
In practice, if I type in the box test "words" and hit space, the box "review 01 track remains empty

[RuralGuy]

I'm sorry but you lost me again. You have 3 controls on the form you supplied.
1) a textbox named "IDCD"
2) a ComboBox named "parole"
3) a textbox named "Recensione_traccia_01"

Maybe if you user the control names I would better understand.

[sergran]

Sorry for the confusion ... I'll explain:
I type in the ComboBox "words" the word, then press "space" key and this happens:
[code] = Me.Recensione_traccia_01.Value Me.Recensione_traccia_01 & Me.parole [/ code] then the focus back on the ComboBox "words".
My problem is that when the focus back on the ComboBox "words", is automatically a space "".
I would like this space there was

[RuralGuy]

Make this change to the code:

Private Sub Form_KeyPress(KeyAscii As Integer)
   If Screen.ActiveControl.Name = "parole" Then
      If KeyAscii = 32 Then
         '-- Append the value in the "parole" cbo to the "Recensione_traccia_01" textbox
         Me.Recensione_traccia_01 = Me.Recensione_traccia_01 & Me.parole
         '-- Clear the "parole" cbo for the next selection
         Me.parole = Null
         '-- Eat (destroy) the "space" we just got from the keyboard
'         KeyAscii = 0
      End If
   End If
End Sub

[sergran]

Hello, forgive me if I break ... the code works but if you try to type in the combo "words" the word "test" then press space and type in the word "beautiful", the word beautiful is preceded by a space
I attach the db
Thanks

EmptySpace.zip

[RuralGuy]

How about now?

[sergran]

No, unfortunately, does not go ... in practice I type on the combo "words" test, then press "space" and copy me "test" in the combo "recensione_traccia_01", then the focus returns to the "words" and appears a space.
Do you carry a sequence to explain better
combo "words" -> I type test
I press space
"test" is copied to the combo "recensione_traccia_01"
the focus back on the combo "words"
I type test and is not completed because the word before the cursor flashing has formed a "space" (" ")
I'm sorry .. I know I'm driving you crazy with my problem of access

[RuralGuy]

Part of the issue is your names for things:

No, unfortunately, does not go ... in practice I type on the combo "words" test, then press "space" and copy me "test" in the combo "recensione_traccia_01", then the focus returns to the "words" and appears a space.
Do you carry a sequence to explain better
combo "words" -> I type test
There is NO combo control named "words".
I press space
"test" is copied to the combo "recensione_traccia_01"
The "recensione_traccia_01" control is NOT a combo. It is a Textbox.
the focus back on the combo "words"
I type test and is not completed because the word before the cursor flashing has formed a "space" (" ")
I'm sorry .. I know I'm driving you crazy with my problem of access

[sergran]

I'm sorry....
There is NO combo control named "words". ---> "parole"

[RuralGuy]

For some reason it is not easy for me to figure out what you want so here's another guess. It seems you are not very comfortable with VBA.

[sergran]

You're right ... is difficult for me to explain ...
I am attaching the screen-shot
1 -> I write the word (work)
2 -> I press space and the word "Beautiful" is inserted in the textbox "Recensione_traccia_01" (works)
3 -> the tab back on the combobox "parole" and remains one space to the left of the blinking cursor. I wish that space was canceled. Maybe I could use Ltrim? But how? I could not

Thanks very much

[RuralGuy]

I thought in Post #18 you said you *wanted* the space so we put it back in. Where do you want the space to go?

[RuralGuy]

BTW, there is nothing in your screen-shot.zip file.

[sergran]

Screen-shot1.zip excuse Hello

[RuralGuy]

Now show the sequence for the *next* word typed please. Does this do as you want?