i have a form with a list of customers
for finding a name on the list user write's the name in a text box
the code i'm using is:
Private Sub TextBox_KeyUp(KeyCode As Integer, Shift As Integer)
   Recalc
   Screen.ActiveControl.OnKeyUp = ""
   SendKeys "{F2}", True  'Press F2 (Goto end of text line)
   TextBox.OnKeyUp = "[Event Procedure]" 'Restore Event
'
   Me.RecordsetClone.FindFirst "left([CustomerName]," & Len(TextBox) & ")
= '" & Me!TextBox & "'"
   Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub

while user write's the last name it's working ok
but when entering space between last name and first name, space disapears
and name can't be found

have an idea?

thanks
sam