Listbox ListRows problem

I have a simple form with a listbox that lists the results of a search.  I'm very disapointed that for some reason it will only show a certain number of the results in the listbox, even when it scrolls.  

For instance, I may get 30 results from my search, and only 13 will show up in the list box.  

I have read somewhere that I should use the listrows property.  Where do I use this, and how do I set it?  I tried to put it in the event 'On Load' for the form that loads, but it doesn't work.  Can I specifically say list1.listrows = 255 or something like that???  I'm confused.
ddreeseAsked:
Who is Participating?
 
AccQCommented:
Interesting that when typing in the code, ListRows does not display when I type "myList.", yet the code does seem to work. I'm not an expert, but here's what I did. I used the following code:

Form_Load
myList.ListRows = 200
End Sub

My table only has 44 records, but all 44 showed up in the list box. Try it and see if it works. (I have Access 2000).
0
 
ddreeseAuthor Commented:
Yea I thought that was interesting too.  I had tried to type in that code, but it didn't seem to work for me.  I did a search on google though and found the following code that seems to have fixed it:

Dim ListControl As Control

Set ListControl = List2

ListRows = List2.ListCount

I'm not sure why that works when I hardcoding it didn't seem to work:

List2.ListRows = 255

Thank you for your quick response though!
0
 
AccQCommented:
Glad your problem is solved. If you would like to ask for a refund for this question, just post your request for refund in the Community Support ("CS") section. Thanks.
0
 
ddreeseAuthor Commented:
That won't be necessary, I have plenty of points to go around :)  Thanks again for your help.
0
 
AccQCommented:
It is pleasant to get points for learning something. Kind of like being in school, without the torture of final exams. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.