title: How to display concatenated value in MS Access Combobox
body: <p>I'm trying to fill the combobox with values from a concatenated field in a MS Access query.  The embedded image is what is currently shown in the drop down box and what is shown in the box when a value is selected.</p>
  
  <p>The problem is that i do NOT want the values in the drop down box to show as if in columns, but rather as a concatenated string.  So, instead of ... TAYLOR  |  AVICHAI ... it should be TAYLOR, AVICHAI.  And additionally, when the value is selected, then instead of showing just TAYLOR it would show TAYLOR, AVICHAI.</p>
  
  <p>I've tried every property I can think of and tried concatenating in the original table, the query and even in vba code AFTER just grabbing the two fields from the database.</p>
  
  <p>Any help?  <a href="http://i.stack.imgur.com/2psH1.png" rel="nofollow">Concatenated View</a></p>