Pre load combo

B

Bernard

Hi Is it possible to preload comboboxes memory to allow
for smooth scrolling of data in them. I have found them
to be slow and have to recalculate position and size of
scroll bar until one full cycle of all records is done.

Thanks

Bernard
 
K

Ken Snell [MVP]

Yes. In the form's Load event, use code like this:

Private Sub Form_Load()
Dim lngCount As Long
lngCount = Me.ComboBoxName.ListCount
End Sub
 
Top