Results displayed in list box limited by physical size of listbox?

[Tom Mackay]

I built a form that allows users to select from a number of client attributes
and displays the results in a subform/listbox after executing the search.

Funny thing is that the results displayed seem to be limited by the physical
size of the listbox? That is, even if the # of records fulfilled by the
search is 100, the listbox will only display 30 records...despite the fact
that the underlying query itself, when checked, retrieves all 100 records
successfully. Second funnier thing is that sometimes, it works properly?
Maybe when I first open the form, but it quickly reverts to the incorrect
mode...but this is inconsistent.

Any help is appreciated,
Txs,
Tom

Here's the Search command code:
Private Sub CommandSearch_Click()
[Forms]![GroupEmail]![ListBoxClients].Requery
End Sub

and some relevant attributes of ListBoxClients?:
Control Source is blank
Row SourceType is Table/Query
Row Source is Query1

 

[boblarson]

I just tested one for me and it worked fine. What version of Access are you
using? Also, you might have a corrupt form. Have you tried importing all of
your objects into a brand new, blank mdb file and deleting the current list
box and adding it back in again?

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Tom Mackay]

Rebuilding the list box seems to have cleared the problem up...for now. I
will keep that tactic in mind as I continue. Thanks again.

I just tested one for me and it worked fine. What version of Access are you
using? Also, you might have a corrupt form. Have you tried importing all of
your objects into a brand new, blank mdb file and deleting the current list
box and adding it back in again?

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

I built a form that allows users to select from a number of client attributes
and displays the results in a subform/listbox after executing the search.

Funny thing is that the results displayed seem to be limited by the physical
size of the listbox? That is, even if the # of records fulfilled by the
search is 100, the listbox will only display 30 records...despite the fact
that the underlying query itself, when checked, retrieves all 100 records
successfully. Second funnier thing is that sometimes, it works properly?
Maybe when I first open the form, but it quickly reverts to the incorrect
mode...but this is inconsistent.

Any help is appreciated,
Txs,
Tom

Here's the Search command code:
Private Sub CommandSearch_Click()
[Forms]![GroupEmail]![ListBoxClients].Requery
End Sub

and some relevant attributes of ListBoxClients?:
Control Source is blank
Row SourceType is Table/Query
Row Source is Query1