How to make combo box list bigger?

E

Emma

I have a drop down menu that has text in the fields unfortunately the user
can't tread it because the list isn't wide enough how do I change the width?
 
J

Jerry Whittle

Assuming this is in a form, open the form in Design View. Right click on the
combo box and bring up Properties. Go to the Format tab.

First look at the Column Count. If it's 1, things will be simple. In that
case drop down to Column Widths and put something like 3" which is 3 inches
wide. Next drop down to List Width and make it at least as wide as what you
put up in Column Widths.

Now if the Column Count is more than 1, such as 3, you put in something like
0";3";3". The first column will be invisible. The second will be 3" and so
will the third column. The list width needs to be as least as wide as the sum
of the above columns. In this instance, 6".

Next you need to decide if the actual combo box needs to be wider. If so go
down to the Width property to change it. I'd more than likely make it 3" in
the cases above as the columns are 3". That way you can see all that the
combo box displays.
 
E

Emma

Thanks Jerry, it worked fine

Jerry Whittle said:
Assuming this is in a form, open the form in Design View. Right click on the
combo box and bring up Properties. Go to the Format tab.

First look at the Column Count. If it's 1, things will be simple. In that
case drop down to Column Widths and put something like 3" which is 3 inches
wide. Next drop down to List Width and make it at least as wide as what you
put up in Column Widths.

Now if the Column Count is more than 1, such as 3, you put in something like
0";3";3". The first column will be invisible. The second will be 3" and so
will the third column. The list width needs to be as least as wide as the sum
of the above columns. In this instance, 6".

Next you need to decide if the actual combo box needs to be wider. If so go
down to the Width property to change it. I'd more than likely make it 3" in
the cases above as the columns are 3". That way you can see all that the
combo box displays.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top