ComboBox scroll

[Guest]

Hi,
I have a form with a combo box on it which when clicked on displays about
100 records. When I click on the box in the scroll bar and pull it down the
list dose not scroll. When I unclick the list then changes. Once I have
done that the list scrolls with the scroll bar box. If I then enter the
combo box again the list scrolls with the box the way it should. Why dosen't
it work the first time???? Any Ideas?

Thanks,

 

[Al Camp]

Phil,
Access doesn't query all the records in the combo at first. It first displays just the
records that will show when the the drop down is selected. This allows the combo to "free
up" for data entry much sooner than if the whole recordset had to load.
Once you've scrolled past all the records, they are then loaded into memory, so that
scrolling hesitation no longer occurs. However, whenever the combo is requeried, or
"re-loaded", the above occurs again.

The most effective way to quickly access items in a large combo box is to use
AutoComplete to your advantage. It can locate the record as you type without loading them
all... even in large combos.

 

[Stephen Lebans]

In the Form Load event try this:
' If we access the ListIndex property
' then the entire Index for the RowSource
' behind each ListBox or Combo is loaded.
' Allows for smoother initial scrolling.
Dim lngTemp As Long
lngTemp = Me.List4.ListCount


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.