Scrollbars

[James]

This is something that has annoyed me for a while and I
am now designing a datbase where there will be a listbox
with about 8,000 entries.

Is there anyway to get the listbox to automatically
calculate how big the vertical scroll bar should be? With
6,000 entries if you drag the scrollbar down to the
bottom it only goes down about 300 rows and then resets
half way up and it takes about 20 scrolls to get to the
bottom.

I am using Access 2002 on Windows XP. Any help would be
appreciated.

 

[Steve Schapel]

James,

I think it will help to put code like this on the Load event of the form...
Dim lngTemp As Long
lngTemp = Me.NameOfYourListbox.ListCount