List box scroll bar

[Max Moor]

I have a problem with a vertical scroll bar on a listbox with 1000+ items.
If I pull the thumb to the bottom, it springs back to the middle of the
scroll bar, and displays a record some 200 into the list. It's as if the
scroll bar isn't properly indexed. Eventually, I can scroll to the bottom
by paging below the thumb, but it's annoying. I've noticed this behavior
in large lists before, but never asked the question... can I do anything
to fix this? Does it sound familiar to anyone?

 

[Rick Brandt]

I have a problem with a vertical scroll bar on a listbox with 1000+ items.
If I pull the thumb to the bottom, it springs back to the middle of the
scroll bar, and displays a record some 200 into the list. It's as if the
scroll bar isn't properly indexed. Eventually, I can scroll to the bottom
by paging below the thumb, but it's annoying. I've noticed this behavior
in large lists before, but never asked the question... can I do anything
to fix this? Does it sound familiar to anyone?

It's caused by the fact that the list is displayed before all of the rows have
been fetched. Once you navigate to the last item, then Access can properly
evaluate the percentage of the list for the thumb. I believe if you have code
evaluate the ListCount property when the form is loaded that this will force the
list to fully populate, but that might result in a delay if you have a big list.