Inaccurate Combo list count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to get a count of items in a combo box with the following code,
but it's giving me a wrong number. The combo only shows 3 items when the
following code gives me 4.
msgbox (Me![cboSerialNumber].ListCount)

What's wrong with the above code? Currently using MsAccess 2000. Any help is
greatly appreciated.
 
Hi Samantha

If you have column headings turned on in your combo or list box, then the
headings are counted as one of the list rows, so ListCount (and also
ListIndex) will be one greater than you expect it to be.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Records in a combo box 2
Record Counts 7
2 list box iteration 1
Can you auto write AddItem VBA code to a form to populate a Combo 5
Combo Box Null 1
Test for a Combo Box empty or not... 4
Combo Box & Report Questions 22
Problem counting items in List Box 5

Back
Top