[AccessD] Combo Box RowCount

Arthur,

Off on a tangent here... You know how sometimes if you have a goodly number 
of items in a combobox, scrolling down through them can be a bit spastic 
because Access is loading them as you go down?  Well, as a little trick, you 
can use code like this:
   Dim i As Integer
   i = Me.MyCombo.ListCount
... for example on the Enter event of the combobox, which forces all list 
items to be loaded, and therefore avoids the staggered scrolling syndrome.

Regards
Steve


--------------------------------------------------
From: "Arthur Fuller" <fuller.artful at gmail.com>
Sent: Sunday, January 25, 2009 6:15 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Combo Box RowCount

> Cool! I didn't know there was such a property. I'll pop in a few 
> debug.print
> statements just to verify that I'm always in synch