Combo Box Auto expand List Width

[Silvio]

it's possible to have a Combo Box List Width (the list only not the combo box
it self) to expand to fit to its contents? I am using Access 2007.

 

[Jeanette Cunningham]

No, a combo box doesn't work that way.
I usually make the list width wide enough to accommodate the longest
content, or the sum of the widths of all the visible columns.
You can change the list width of the combo with code and change the column
width for each column with code.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

I should know by now, to never say no or never.
Thanks for the link.
By the way, have you ever used this code and did it work fine for you?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia