Solved

Listbox ListRows problem

Posted on 2003-10-30
5
257 Views
Last Modified: 2010-08-05
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.
0
Comment
Question by:ddreese
  • 3
  • 2
5 Comments
 
LVL 1

Accepted Solution

by:
AccQ earned 125 total points
ID: 9650543
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
 

Author Comment

by:ddreese
ID: 9650617
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
 
LVL 1

Expert Comment

by:AccQ
ID: 9650836
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
 

Author Comment

by:ddreese
ID: 9651126
That won't be necessary, I have plenty of points to go around :)  Thanks again for your help.
0
 
LVL 1

Expert Comment

by:AccQ
ID: 9651154
It is pleasant to get points for learning something. Kind of like being in school, without the torture of final exams. Thank you.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now