PC Review


Reply
Thread Tools Rate Thread

Combo Box Auto expand List Width

 
 
Silvio
Guest
Posts: n/a
 
      24th May 2010
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.


 
Reply With Quote
 
 
 
 
Jeanette Cunningham
Guest
Posts: n/a
 
      24th May 2010
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" <(E-Mail Removed)> wrote in message
news:B63E4AB4-128A-4269-A510-(E-Mail Removed)...
> 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.
>
>



 
Reply With Quote
 
Jeanette Cunningham
Guest
Posts: n/a
 
      25th May 2010
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@uwe> wrote in message
news:a88146accf0c1@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/insigh...own-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
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box Auto Expand Always OpenTo Suggestions Microsoft Access Forms 0 2nd Nov 2009 03:20 PM
Auto-expand/rich auto-complete option in Excel combo boxes Keith Howard Microsoft Excel Programming 1 21st Mar 2009 04:16 PM
Combo auto expand =?Utf-8?B?SmltIERldmVuaXNo?= Microsoft Access Forms 3 30th Mar 2005 05:55 PM
Apostrophe and Combo Auto Expand Tim S Microsoft Access ADP SQL Server 0 16th Jun 2004 10:11 PM
Auto Expand Combo Box TimH Microsoft Excel Programming 1 6th Nov 2003 06:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:43 PM.