Problem fully populating combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that contains a list of approximately 400 names. When
the box is selected Access only displays the requested number of names
(between 1 and 255 as selected in the properties. Unfortunately, the scroll
bar only partially works. You can scroll down to about 1/3 of the list and
it registers it is at the end of the list.

Suspecting a slow population problem, I have based the combo box on a query
rather than SQL. It still doesn't help.

Any suggestions would be greatly appreciated.
 
I wonder why it is not working for you. I have a combo box looking up
multiple fields from close to 3300 records and it is displaying the entire
list. You did say you have set it up as a query from the table right?
 
Yes. The query is based on a single table with three fields. Nothing
unusual about the fields either, 50 text characters for each.

The reason I initially suspected a slow population problem was if I let the
form sit a minute or so without accessing the combo box, I would
occassionally get the fully populated combo box. So I based it the box on a
query -- but it didn't seem to help.

I'm beginning to wonder if some code in my event procedures may halt the
population of the combo box. I guess I'll take a look for that potential
problem if all else fails.
 
Back
Top