Listbox not showing all records

[BigJimSlade]

Hey, Big Jim here:

I have a listbox whose RowSource is set to a query. When I press a button on the form, the RowSource changes and the listbox should fill with thousands (7,000+) rows. However, it only populates the first 20 to 30 rows.

Is there anyway to force the listbox to populate with every single record in the RowSource query?

Thanks in advance....

Big Jim

 

[Fuga]

I have a listbox whose RowSource is set to a query. When I press a button on the form, the RowSource changes and the listbox should fill with thousands (7,000+) rows. However, it only populates the first 20 to 30 rows.

Are you sure the rowsource is actually changed and your form is refreshed if necessary (me.refresh)?

If so, if you run your query, does it return 7000+ records?

Fuga.

 

[BigJimSlade]

Hi Fuga,

Yes, the query is a functional query, I have tested it. Also, if I click the mouse on the scrollbar inbetween the down arrow and the bar itself (the part that moves up and down the scrollbar) I am able to eventually populate all records. Otherwise, the records do not populate.

Thanks again!

Big Jim

 

[BigJimSlade]

Thanks Pat. I always appreciate when you spell out the limitations of Access. It helps Big Jim design better in the future.

I do think it is interesting however that in VB, you can populate listboxes row by row as opposed to using a Table\Query Rowsource, and the listbox will show all appended.

Thanks again!

 

[BigJimSlade]

Thanks, Pat.

I will take a look at it first thing in the morning. I must admit that I am scared when there is something in Access that you "barely understand". That means the rest of us should stop trying.

Thanks again!

Big Jim

 

[BigJimSlade]

Wow!

Let me say that again......Wow!

Big Jim loves the easy answers! Thanks, Pat! There will be many people at my company quite relieved that they can see their entire lists at one time.

Thanks again!

Big Jim Slade