Combo box scroll bar freezes

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have an Access97 app that fills a combo box with records
from a linked table. When I open the combo box and click
a couple times on the scroll bar the combo box will
sometimes freeze and only display a portion of the
underlying data. This doesn't happen all the time and
also doesn't happen if the arrow down or any other method
is used to navigate the combo box. The underlying query
uses a sort on a text field that is 140 chars long. Could
Access be taking too long sorting this field? I've tried
several things including creating an index on the text
field and simplifying the underlying query as much as
possible. Any help or suggestions would be greatly
appreciated.
Steve
 
The Access UI that control's the ListBox/Combo's Scrollbar need's some
help to ascertain exactly how many rows are currently in the Listbox.
In the Form's Load event do something like:

Dim lCount as long
lCount = Me.NameOfYourListBoxorCombo.ListCount


--

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