Calculating the number of records in a listbox/combo box

's Computer Specifications

Is there a way to programmatically determine the total number of records in a
listbox/combox?

's Computer Specifications

"CrazyAccessProgrammer" <(E-Mail Removed)>
wrote in message news:7EA99E65-CAA7-4913-AD0D-(E-Mail Removed)...
> Is there a way to programmatically determine the total number of records
> in a
> listbox/combox?

Debug.Print Me.LstCtrls.ListCount

's Computer Specifications

Use the ListCount property of the control.

TheCount = Forms![FormName]![ComboboxName].ListCount

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

CrazyAccessProgrammer wrote:
> Is there a way to programmatically determine the total number of records in a
> listbox/combox?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating number of days between dates for records in the same t	Dan	Microsoft Access Queries	0	5th Mar 2008 04:25 PM
Check number of records in subform according to listbox	tsuby@libero.it	Microsoft Access Getting Started	0	19th Jul 2006 12:53 PM
Count number of records in ListBox	HearSay	Microsoft Access Forms	2	1st May 2006 07:44 PM
No Records on Listbox - Controlled by Combo Box	Jen Preston via AccessMonster.com	Microsoft Access Form Coding	2	9th May 2005 05:26 PM
Calculating total number of records	little_rascals	Microsoft Access	2	9th Mar 2004 07:06 AM