Displaying More Rows in a List Box

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

Guest

I'm using Access 2003 and would like to display multiple rows in a list box
on a form. I don't see a parameter in the properties that will enable me to
display more than the single line that is currently displayed.

Thanks.
 
Scott said:
I'm using Access 2003 and would like to display multiple rows in a
list box on a form. I don't see a parameter in the properties that
will enable me to display more than the single line that is currently
displayed.

Thanks.
Click to expand...

You mean multple rows (per row) of the RowSource query? You can't do that.

If you mean multiple rows OF the RowSource query just make the ListBox taller.
 
Assuming that you mean you want entries in the list box to span more than
one row, it's not possible.

If you're talking about the ability to select more than one entry in the
list box, look at its MultiSelect property.
 
Thanks for the quick response. I'll try to be more specific:

I'm only interested in one row per entry, so that's not a problem. However,
when the user tabs into the field and clicks on the arrows, I would have
expected the list box to drop down and display more of the available choices.
However, it continues to display only one row. Clicking on the arrows
cycles through the entries, but it would be helpful to see more than one at a
time. Ideally, I'd like to be able to specify that the list box would drop
down to display 3 or 5 choices at a time.

Thanks.
 
Scott said:
Thanks for the quick response. I'll try to be more specific:

I'm only interested in one row per entry, so that's not a problem.
However, when the user tabs into the field and clicks on the arrows,
I would have expected the list box to drop down and display more of
the available choices. However, it continues to display only one row.
Clicking on the arrows cycles through the entries, but it would be
helpful to see more than one at a time. Ideally, I'd like to be able
to specify that the list box would drop down to display 3 or 5
choices at a time.
Click to expand...

The behavior you want comes from a ComboBox, not a ListBox.
 
Back
Top