Pasting into ComboBox acting weird

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the problem:


Running Windows 2000 with Office 2000 or Office XP I can Copy some text from
a form and Paste it into a combobox. When I paste the text, the combobox
goes to the record with that text...much like it does when you type it in.

However....
Running Windows XP (Pro/Home) with Office 2000/XP, I can type text and the
combo box will go to the record, but when I try copying and pasting into one,
it doesn't work! I have to hit Backspace and typr in the letter that I just
deleted!

This is really annoying. I have been trying to figure this out the best I
can on my own, but to no avail. I have no idea why it works on Win 2000 with
any version of Office, but will not work in Win XP with any version of
Office. So the only thing I can think of is to code it. I have been trying
the following code, but it keeps throwing out errors and won't work....

Dim varX As Variant
Dim strY As String
Dim lngY As Long
strY = Me.ComboTest.Text
lngY = Len(strY)
varX = DLookup("[LastName]", "Employees", "Left([LastName], lngY) = strY")
Me.ComboTest.Text = varX


Thanks in advance for ANY help provided on this.
 
Never mind....I found a work around.

I just used a Do...Until Loop to search the combo for the record.
Then I used an if statement to say that if it found it, set the combo equal
to that value, if not, throw an error.
 
Back
Top