Home > Ms Access > Ms Access Combobox Auto Expand Not Working

Ms Access Combobox Auto Expand Not Working

Close this window and log in. it doesn't auto expand, but it will give you a not in list error)?The row source type is set to table/query and the row source is set to a specific query Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Eventually the list of SampleID's is going to get rather lengthy, so the AuotExpand feature is necessary....scrolling wouldn't work. Check This Out

A combo will only drop-down when you click on the down arrow OR if you have used code to tell it to do so. Please try the request again. That is AutoExpand. I'll re-install access and see if that cures anything...... 0 Message Author Comment by:TownTalk2011-03-30 Comment Utility Permalink(# a35257863) I've repaired MS Access and i've still got the same problem. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/combo-box-property-auto-expand-yes-doesnt-seem-to/05fa61af-853e-4c9d-a3e3-2f51aa094668

I've tried this sample database on another machine running Access 2010 and got the same behaviour. A combo will only drop-down when you click on the down arrow OR if you have used code to tell it to do so. There are two fields in the row source: SELECT DISTINCTROW TBL_TOWN.TCODE, TBL_TOWN.TNAME FROM TBL_TOWN ORDER BY TBL_TOWN.TNAME; First visible field is TNAME. SUBSCRIBE Join & Write a Comment Already a member?

First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Reports :: Conditionally Expand Chart Onto Multiple Pages Combo Boxes Stop Working After Returning To Form Forms :: Combo Box - Search Function Not Working Within Form Forms :: Requery Not I have tried the following: 1) removing the combobox and putting on a fresh one, running repair, making an entire 2nd form from scratch, etc. 2) making the NOT IN LIST Create Form2 with one combo ...

Is this because the source of the ComboBox is a query. Have you all updates installed? 0 Message Author Comment by:TownTalk2011-03-30 Comment Utility Permalink(# a35258077) What do you make of this?....... the scrolling is horrible, so that is not acceptable without autoexpand.Somebody out there having experience with this kind of trouble? I > see that the combo box is in fact the newly created object.

LVL 38 MS Access26 26 Comments LVL 39 Overall: Level 39 MS Access 32 Message Active today Expert Comment by:als3152011-03-29 Comment Utility Permalink(# a35249663) May be you can send us Tanks for any help. Louis City", it allows me to enter this value. Aug 22, 2014 I have a report that needs to show about 20 different fields from 24 records.

I'm copying in that post below. >>>>>>>>>>>>>>>>>> "RobGMiller" wrote: Access 2003. https://bytes.com/topic/access/answers/850371-combobox-property-auto-expand-combobox-doesnt-open-typing Reopend the Form, and BOTH combos worked !! it continues to work! ....... Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use.

The problem happens when I set the criteria under ItemSupplier, the criteria being the supplier ID, the combo box no longer expands and searches as you type, but the items in http://amptools.net/ms-access/ms-access-right-click-not-working.html I tried creating a new database and importing the faulty form after removing all controls and events from the form except for the combo box. Similar topics autoexpand Autoexpand does not work autoexpand