combobox question

I have a combo box with 12 columns on my form. However,
when I click on the drop down arrow, I can only see 10 of
the columns. How can I see all of the columns? I have
tried changing column widths but that hasn't helped.

Thanks for the help......

columnwidths in conjunction with the listwidth property of the combobox
would be the properties to use.

for example, I did 13 columns
ColumnWidths:
20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20
pt
ListWidth:
280pt
columncount:
13
Rowsource:
Sheet1:A2:M25
columnheads:
True

for the listwidth
add up all your columnwidths and add some pts for the vertical scroll bar.
(I added 20 pts).

--
Regards,
Tom Ogilvy

"JT" <[email protected]> wrote in message
news:[email protected]...
> I have a combo box with 12 columns on my form. However,
> when I click on the drop down arrow, I can only see 10 of
> the columns. How can I see all of the columns? I have
> tried changing column widths but that hasn't helped.
>
> Thanks for the help......

Tom.........thanks for the help......JT

>-----Original Message-----
>columnwidths in conjunction with the listwidth property
of the combobox
>would be the properties to use.
>
>for example, I did 13 columns
>ColumnWidths:
>20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20
pt;20 pt;20 pt;20
>pt
>ListWidth:
>280pt
>columncount:
>13
>Rowsource:
>Sheet1:A2:M25
>columnheads:
>True
>
>for the listwidth
>add up all your columnwidths and add some pts for the
vertical scroll bar.
>(I added 20 pts).
>
>--
>Regards,
>Tom Ogilvy
>
>"JT" <[email protected]> wrote in
message
>news:[email protected]...
>> I have a combo box with 12 columns on my form. However,
>> when I click on the drop down arrow, I can only see 10
of
>> the columns. How can I see all of the columns? I have
>> tried changing column widths but that hasn't helped.
>>
>> Thanks for the help......
>
>
>.
>

Tom.........thanks for the help......JT

>-----Original Message-----
>columnwidths in conjunction with the listwidth property
of the combobox
>would be the properties to use.
>
>for example, I did 13 columns
>ColumnWidths:
>20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20 pt;20
pt;20 pt;20 pt;20
>pt
>ListWidth:
>280pt
>columncount:
>13
>Rowsource:
>Sheet1:A2:M25
>columnheads:
>True
>
>for the listwidth
>add up all your columnwidths and add some pts for the
vertical scroll bar.
>(I added 20 pts).
>
>--
>Regards,
>Tom Ogilvy
>
>"JT" <[email protected]> wrote in
message
>news:[email protected]...
>> I have a combo box with 12 columns on my form. However,
>> when I click on the drop down arrow, I can only see 10
of
>> the columns. How can I see all of the columns? I have
>> tried changing column widths but that hasn't helped.
>>
>> Thanks for the help......
>
>
>.
>