Question Automating the Width in Combo Boxes?

[ACM]

I've set the 'List Width' of my combo box as "Auto". However, the problem is that it doesn't actually adjust the width of it according to the longest text length in the combo box (as shown below). How can I automate it so it works?

http://img27.imageshack.us/img27/9516/56884497.jpg

 

[dcb]

Firstly I love the data in the list box!!!!

Are you looking to adjust the box itself or the size of the list?
Why dont you just set the list & Box Size to the width of the longest team? then there are no dynamics...

I am hoping that your current selection actually get some silverware this season - but thats another debate completely! (esp after last sun....)

 

[ACM]

Are you looking to adjust the box itself or the size of the list?
Why dont you just set the list & Box Size to the width of the longest team? then there are no dynamics...

I'm looking to adjust the size of the list. I was just wondering why it's not automatically adjusting the width as I have it on "Auto". But I guess I could just do it manually anyway.

 

[dcb]

I THINK the auto function actually gets its width from the sum of the columns width... It would make sense as if your column width is set to 2.5 there would be no point in the list being wider....

 

[ACM]

I THINK the auto function actually gets its width from the sum of the columns width... It would make sense as if your column width is set to 2.5 there would be no point in the list being wider....

Ah yes, thank you. It does, so now I know.

 

[ACM]

The problem now is I can't seem to put more than a certain number of entries in the combo box to be used for the 'Nationality' column. I have 201 entries, but when I put them in and click 'OK', the bottom few, with nationalities beginning with T onwards are ignored. I can't seem to increase this limit. Is this problem resolved if I use MySQL?

 

[boblarson]

You are manually typing them in as a value list? If you have that many, create a table to store them and use a query as the row source.