[AccessD] Combo Box RowCount

Wow,

Great tidbit. Another one for the tool belt.

Thanks Steve 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Saturday, January 24, 2009 10:02 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com