Combox with VBA-Auto

KerryDee

Registered User.
Local time
Today, 13:43
Joined
Nov 24, 2016
Messages
36
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
 

Attachments

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)
 
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)>
 
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.)
 
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.
 
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
 
Thanks guys again I was able to get it to work by placing the codes in the After Event in the property field.
 
I placed the code in the After Update in the properties instead of the Change property.
 

Users who are viewing this thread

Back
Top Bottom