resizing a Combo Box

[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

 

[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

 

[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.

 

[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

 

[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,