Prev: On Close assign a value
Next: How to add record in Subform which is in another Subform
From: Silvio on 24 May 2010 15:41
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.


From: Jeanette Cunningham on 24 May 2010 17:11
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

"Silvio" <Silvio(a)discussions.microsoft.com> wrote in message
news:B63E4AB4-128A-4269-A510-5D8FD75CD70C(a)microsoft.com...
> 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.
>
>


From: Linq Adams via AccessMonster.com on 24 May 2010 19:38
Actually, ADezii on the Access Forum at Bytes.com has some code for doing
this very thing, without the use of APIs, etc.:

http://bytes.com/topic/access/insights/830511-how-dynamically-set-combo-drop-down-list-width


--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

From: Jeanette Cunningham on 25 May 2010 00:14
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

"Linq Adams via AccessMonster.com" <u28780(a)uwe> wrote in message
news:a88146accf0c1(a)uwe...
> Actually, ADezii on the Access Forum at Bytes.com has some code for doing
> this very thing, without the use of APIs, etc.:
>
> http://bytes.com/topic/access/insights/830511-how-dynamically-set-combo-drop-down-list-width
>
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000/2003
>
> Message posted via http://www.accessmonster.com
>


From: Linq Adams via AccessMonster.com on 25 May 2010 12:29
No, never had the need, but I have heard from a number of developers who have
and were very happy with it!

BTW, Having reached the age of 60 this past year, I find myself saying "no"
or "never" less and less!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: On Close assign a value
Next: How to add record in Subform which is in another Subform