combobox question

[JT]

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 Ogilvy]

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

 

[JT]

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




.