Combo Box Auto Expand Problem (1 Viewer)

DaveLowe · Jan 13, 2011

I am using Access 2010 and have a number of instances of combo boxes on various screens I have designed for an order tracking system.

The autoexpand property in these combo boxes is set to yes however it fails to work.

I have tried recreating the combo box objects and switching the autoexpand property on and off several times however nothing seems to work.

The lists for these combo boxes are a variety of simple select queries or individual tables in a properly normalised database.

Any help would be greatly appreciated.

missinglinq · Jan 13, 2011

Are you sure that the data you're entering matches a selection in the bound column for the Combobox?

It's not uncommon, when creating a Combobox, to include a PK, usually an AutoNumber, and then to set that column's width to 0" so that it doesn't actually appear in the dropdown. If that column is the bound column, and the user enters a name, for instance, that is in the second, visible column, AutoExpand won't function as expected.

Linq ;0)>

DaveLowe · Jan 13, 2011

Thats great

Thank you very much for your help

missinglinq · Jan 13, 2011

Was that it?

Rx_ · Jan 24, 2012

Validated: I am using Access 2010 and had the same problem.
With the RowSource showing an Index in the first column the user could not type in selections on the list.

Procedure:
In the Row Source Query for the Combo Box, move the Index to the second column as you suggested.
Be sure to change the Bound Column to 0 reflect the new location of the pull-down list items.
Also remember in the Format - Column Widths
Example: It is common to have a List Width of 1"
In the Column Widths hiding the index and showing the data as 0";1"
Change that to 1";0" to show the values in the list box and hide the index now relocated in the second column.

Thanks, I had forgotten about that for the moment. Your solution saved me the time to remember.

missinglinq · Jan 24, 2012

Glad we could help you, too!

Linq ;0)>

jai kushwaha · Jan 1, 2016

I have a problem with the combo box on my form. I have a combo box "driver name" and the row source is a table and I selected "auto expand" property to yes but when I am typing it is not expanding the values on the behalf of the character I am typing and I dont know what to do ?? please help..

bob fitz · Jan 1, 2016

jai kushwaha said:
I have a problem with the combo box on my form. I have a combo box "driver name" and the row source is a table and I selected "auto expand" property to yes but when I am typing it is not expanding the values on the behalf of the character I am typing and I dont know what to do ?? please help..

Have you read and understood post #2 in this thread.

jai kushwaha · Jan 1, 2016

yes but it is not working for me if I typed value in combo box it is working but if I call a value from table it is not working. I am using ms access 2013.

well thnx for reply I need solution thank you friend..

bob fitz · Jan 1, 2016

What do you mean by:

jai kushwaha said:
... but if I call a value from table.....

jai kushwaha · Jan 2, 2016

my mean is that if I using record source for combo box a table/query than auto expand property of combo box is not working.

jai kushwaha · Jan 2, 2016

if I am using value list as row source type in combo box and typing the value the auto expand property is working but if I am using table/query as row source type then auto expand property of combo box is not working.

bob fitz · Jan 2, 2016

Can you post a copy of your db.

jai kushwaha · Jan 2, 2016

I am using internet from mobile so I cant do it now?? any suggestion

bob fitz · Jan 3, 2016

Can you tell us the settings of the following combo box properties:

Row Source Type
Row Source
Column Count
Column Widths
Bound Column

arnelgp · Jan 3, 2016

lets make things clear, auto expand is not same as dropdown. auto expand is when you type something in the combobox, when it finds a match on the substring you are typing, displays the most likely match.

jai kushwaha · Jan 9, 2016

can some tell me that how to distribute database to different computer for real time use ?
is it possible to distribute the database to different cites and countries??

jai kushwaha · Jan 9, 2016

arnelgp said:
lets make things clear, auto expand is not same as dropdown. auto expand is when you type something in the combobox, when it finds a match on the substring you are typing, displays the most likely match.

i used distinct keyword and now it is working....

thank you

Combo Box Auto Expand Problem (1 Viewer)

DaveLowe

New member

missinglinq

AWF VIP

DaveLowe

New member

missinglinq

AWF VIP

Rx_

Nothing In Moderation

missinglinq

AWF VIP

jai kushwaha

Registered User.

bob fitz

AWF VIP

jai kushwaha

Registered User.

bob fitz

AWF VIP

jai kushwaha

Registered User.

jai kushwaha

Registered User.

bob fitz

AWF VIP

jai kushwaha

Registered User.

bob fitz

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

jai kushwaha

Registered User.

jai kushwaha

Registered User.

Similar threads

Users who are viewing this thread