Combox with VBA-Auto

[KerryDee]

Hi I was able to receive valuable help with VBA codes on the attached DB. Can anyone help me figure out how to enable the Combo Box to Auto Expand the Comb Box when typing in the field?

Thank you very much!!!

KerryDee

 

[CJ_London]

in the combo properties, format tab, change the list rows from 1 to say 10, 15 or 20, whatever number that seems right for your purposes (but not so many that the list disappears off the bottom of the screen)

 

[missinglinq]

I'm confused! The Auto Expand Property refers to the cbo's ability to move to the first matching selection vis-à-vis each character you type into the box...and, by default, is set to Yes.

The List Rows Property refers to how many selections are displayed when the Combobox is 'dropped down,' and it default to 15 or 16, if I remember correctly, but has nothing to do with entering data into the box.

In plain language, what you are trying to do, here?

Linq ;0)>

 

[Cronk]

In the attached db in #1, the list rows property for the two combos in the form is set at one so only one row is shown. Change it to say 15. (List rows property is in the format tab of the combos' properties.)

 

[mjdemaris]

Yep, you want the ListRows set to more than one. Otherwise you can only see the one, and what use is that in your combo box?

Also, change the event to after update, otherwise you cannot type more than one character into the box. Example: I cannot find AAAAAA in the list just by typing.

 

[KerryDee]

Thanks to all for your input and I will try all suggestions. I am sorry for not responding sooner. To answer missinglinq's question. I am trying to accomplish exactly what mjdemaris points out. For example, typing in the combox, Ker and the combox completes the rest if Kerry exists.

10,000 thanks!!!

KerryDee

 

[KerryDee]

Thanks guys again I was able to get it to work by placing the codes in the After Event in the property field.

 

[mjdemaris]

Glad you got it! What is your solution?

 

[KerryDee]

I placed the code in the After Update in the properties instead of the Change property.