This is something which is fairly simple, but I have no idea how to do it.<br><br>I have a "JobCombo" Combo Box on a form. The user selects which job they want, from the pull-down list which displays the "Department", "Job No" and "Job Name". ("Job No" being the bound, and key column).<br><br>The problem is that only the "Department" ends up being displayed in the combo box. I need for all three fields to be displayed in the combo box. I've tried various methods, but in the end, I have no idea. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Displaying information in a combo
- Thread starter Earth
- Start date
yeah, change the "Column Count" property to 3, adjust the "Column Widths" property accordingly (try something like 1";1";1"
, put the "Bound Column" to 2, and change the "List Width" to equal the sum of the three column widths (in my example it would be 3".<br><br>this should do it for you. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
, put the "Bound Column" to 2, and change the "List Width" to equal the sum of the three column widths (in my example it would be 3".<br><br>this should do it for you. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br> - Thread starter
- #3
I actually already had that set up what famousb suggested, which is why I found this to be so frustrating.<br><br>The combo box stores the correct information from the item selected from the list; it just not display it to the user IN the combo box on the form. I have tried making the "List Width" column both equal to, and greater than, the sum of the three column widths, but it still only displays the first column.
If you want all the info to show in one column, then concatenate them together in another column, then hide the other columns by setting their widths to 0", leave the bound column the same.<br><br>This puts them together in the column.<br><br>Exp: [Field1] & " " & [Field2] & " " & [Field3]<br><br>Of course the actual names of your fields need to be used.<br>Also if you are showing the Column Headings, you need to change "Exp" to something meaningful.<br><br>HTH<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question