[dba-VB] Combo box

Charlotte Foust cfoust at infostatsystems.com
Mon Apr 30 10:49:27 CDT 2007

Combos in .Net are actually a kind of datagrid, so just binding the
combo to a multicolumn source (or array or listview, etc.) should give
you multiple columns. 

Charlotte Foust

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Friday, April 27, 2007 10:35 PM
To: dba-vb at databaseadvisors.com
Subject: [dba-VB] Combo box

I am running into the issue of how to display multiple lines in a combo
IIRC this is a "no can do" in the combos in VB.Net but there must be
common workarounds.  
For example I need to allow the user to select a zip code, but he really
needs to see the zip AND the city.  Furthermore my code is going to need
to load a record based on that zip code to get lat/long.
So, is there a way other than using a concatenation of the zip and the
city to display both in the combo?  If I do a concatenation, then I can
no longer use the zip to lookup a record in a recordset since it now has
city data in the string.
John W. Colby
Colby Consulting
dba-VB mailing list
dba-VB at databaseadvisors.com

More information about the dba-VB mailing list