Pre load combo

  • Thread starter Thread starter Bernard
  • Start date Start date
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
 
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
 
Back
Top