Pre load combo

[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

 

[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