Selasa, 19 Juli 2016

RE: [MS_AccessPros] Displaying all items in combo box when toggle is clicked

 

Steve


The column widths and list width go hand-in-hand as you have seen. Another little trick... say you want the description (second column) to show in the dropdown  but hide the bound column in the list. And you need to have the bound column sow in the combo's text area.
1. set the bound column to a width of something really small like 0.001".
2. set the description column to a workable width.

The user will see just the description in the dropdown. After an item is selected, the bound column will show. I use this for US states in address fields.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <jpbrown0127@yahoo.com> wrote :

Hey Darrell, after you asked the question, I answered "Auto", then I went back in and changed it to a number and now I see what I wanted. Thanks for the nudge! Sometimes we get brain farts and over look the simplest things.

Steve
--------------------------------------------
On Mon, 7/18/16, 'Embrey, Darrell' DEmbrey@bcbsm.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Subject: RE: [MS_AccessPros] Displaying all items in combo box when toggle is clicked
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Date: Monday, July 18, 2016, 10:28 AM


 













What is the List
Width property for the combo box?
 
 

Darrell

 


From:
MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com]


Sent: Monday, July 18, 2016 11:24 AM

To: MS_Access_Professionals@yahoogroups.com

Subject: [MS_AccessPros] Diplaying all items in combo
box when toggle is clicked


 
 



I have a form with a combo box. I have a 4 in the column
count and 0";1";1";1" in the column
width. When I click on the combo box it only displays one
item. I have to scroll right in order to see the other
items. How do I get it to show all items at one
time when I click the combo box? Please help!



Steve



__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar