resizing a Combo Box

G

George

Hi, all:

I have a Combo Box (View\Toolbar\Form). The size of this combo box is
1" (Height) and 3" (width).

There are two items for the combo box's input range. However, one of
the item is too long such that when I click on the combo box, this
item is not fully visible. Is there any way to resize this combo box
such that when I click it, the two items will be both visible? Once I
make a new selection or click the combo box again, the combo size will
go back to its original size?

Thanks for any of your help.

George
 
F

FSt1

hi,
is the combo box on a form or on the sheet?
if on the sheet, you cannot set the autosize property. switch to the activeX
sheet combo box. and set the autosize property to true.
if it is on a form, then you can set the autosize property on the property
sheet in the vb editor.

Regards
FSt1
 
J

JLGWhiz

To resize the combobox from the forms toolbar, simply right click the
control, then click and drag by the handles to the size you want. Left click
to exit edit mode. When finished, right click and drag back to the smaller
size. Left click again to exit edit mode.
 
G

George

Hi, FST1:

Thanks.

Actually, I need it for both situation --- on the sheet AND on the
user form. Please advise how to use active X if on the sheet. Please
also advise if on a form.

Regards,

George
 
G

George

Actually, one more question. How to make the drop down list by using
ActiveX and how to setup the drop down list index. I never use ActiveX
before. Thanks again,
 

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