DBCombo

[Juan]

Hi.

I need use a DBCombo in an application and allow the user to input characters while the DBCombo is searching for the complete word in it.

I have a routine that does it but with a ComboBox.

If anybody can help me...


Thanks.

[HeSaidJoe]

under components add the Microsoft DataBound List Controls
add the DBCombo box to your form
'to get the search abilty you need to set this property

set the DBCombo property MatchEntry = 1 'extended

[DrewDog_21]

HeSaidJoe - I am thinking that what Juan means is that he needs the text in the textbox portion of the DBCombo to match the located entry, like in Access when you type directly into an indexed field. I, too, had a routine that would do that with a ComboBox but have had no luck on the DBCombo. Any ideas on this?

[HeSaidJoe]

how the DBCombo works it it brings it to the top
of the list, but not into the text area.
..ie.

JimBob
Jake
Jacquelin
Jamie

if you type Jac the name Jacquelin will be the first
display once you drop the combo down

Jam and Jamie will be the first name...

it does the routine but doesn't display it physically untill you open the dropdown....

least ways, that is my experience with extended matching.

[Juan]

Hi.

Yeah. DrewDog is right.

Anyway i'll be trying with MatchEntry until i get any better solution.

Thanks both.


PD. Forgive me for my english. I'm from Argentina.

[DrewDog_21]

Jasper, "no hay problema" with the English. Anyway, I am in Colombia and I speak good Spanish, so you can email me if you need some English technical things translated.

Let me know (or "¡me advisa!") if and when you find a better solution, and I will do the same for you if I find one.

[Juan]

Gracias...

I'll be in touch.


[email protected]

[DrewDog_21]

Juan and HeSaidJoe and everybody else: I found a class module on Planet Source Code that is a good start on what we are trying to do here. I am in the process of modifying it, because it has a few bugs and it is also designed to work with an Adodc control and not an Ado recordset. It works most of the time. It is a beta version so I am going to try to contact the code author to see if he or she ever developed a final version. Email me if you want in on this.