List Box Vertical Scroll not showing all records

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

Guest

I have a form with multiple list boxes based on queries

Double-clicking on one box displays records based on the query in a list box below, drilling down to the last list box. Because there are more items in the list than space allotted, a vertical scroll bar appears for some of the list boxes. I noticed that in at least one list, there are more records available than the scroll bar allows to show

Suggestions

TIA
jill.
 
Not sure whether it is relevant but there is a limit of
64K rows in ListBox.

Perhaps, if 64K-row limit is reached, you may need to
devise another algorithm using a set of cascaded ListBox
to limit the number of rows returned.

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
I have a form with multiple list boxes based on queries.

Double-clicking on one box displays records based on the
Click to expand...
query in a list box below, drilling down to the last list
box. Because there are more items in the list than space
allotted, a vertical scroll bar appears for some of the
list boxes. I noticed that in at least one list, there
are more records available than the scroll bar allows to
show.
 
Thanks for your response, Van

On one list box, there are only 7 records total. 2 aren't showing. There is room for four records without having to scroll

To explain a little more about the form, I have a list of Divisions, Branches, Projects, Contracts, etc... I double-click on an Activity, and a list of Divisions for that Activity displays underneath. I double-click a Division, and a list of Branches for that Division displays... etc., continuing to drill down to various levels of detail. I then have a click event that hides the lists... for example, if I click on the Division list displayed, it hides lists that are below it based on that Division so that I can choose a different one and display different results

I have been able to get more records to show if I highlight one of the records in the scrolled list, then hide and display that list again. ?? (And, of course, if I make the box larger. But that's not the best solution, because I have limited space with a lot of lists.

If it makes a difference, I'm using Windows XP, Access 2000

Thanks for any and all help

jill

----- Van T. Dinh wrote: ----

Not sure whether it is relevant but there is a limit of
64K rows in ListBox

Perhaps, if 64K-row limit is reached, you may need to
devise another algorithm using a set of cascaded ListBox
to limit the number of rows returned

HT
Van T. Din
MVP (Access



-----Original Message----
I have a form with multiple list boxes based on queries
Click to expand...
query in a list box below, drilling down to the last list
box. Because there are more items in the list than space
allotted, a vertical scroll bar appears for some of the
list boxes. I noticed that in at least one list, there
are more records available than the scroll bar allows to
show
 
This sounds like something I ran into, but I'm not sure.

In the list box properties, there is "Column Widths" and "Column Count".

See if the column widths have the same number of columns represented as the
number in column count. Such as: Column Widths: 0"; 0.5"; 1.5". This would
be representing 3 columns in column count. See if these match each other.

If you don't mind, reply, as I am curious if that's it.

GC


Jill said:
Thanks for your response, Van.

On one list box, there are only 7 records total. 2 aren't showing. There
Click to expand...
is room for four records without having to scroll.
To explain a little more about the form, I have a list of Divisions,
Click to expand...
Branches, Projects, Contracts, etc... I double-click on an Activity, and a
list of Divisions for that Activity displays underneath. I double-click a
Division, and a list of Branches for that Division displays... etc.,
continuing to drill down to various levels of detail. I then have a click
event that hides the lists... for example, if I click on the Division list
displayed, it hides lists that are below it based on that Division so that I
can choose a different one and display different results.
I have been able to get more records to show if I highlight one of the
Click to expand...
records in the scrolled list, then hide and display that list again. ??
(And, of course, if I make the box larger. But that's not the best
solution, because I have limited space with a lot of lists.)
 
That worked! (column count 6, but only 5 being used - changed to column count 5)

Thanks Chip

jill.
 
Back
Top