Formatting a DBComboBox

I have a DBcombobox with a listfield generated from an sql query, the list has multiple fields.

How can I format the list so the fields line up.
When the user makes a selection I only want a subset of the fields  from the selection to be displayed in the text portion of the combobox

       
pchahalAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
milton042297Connect With a Mentor Commented:
You can use the simple vb combobox to make this task.
Take a look in this suppost code:
****************************************************************
set db = OpendataBase("MyDB",true,true)

set MySnap = DB.CreateSnapShot(Select * from myTable were MyField =" & "MyCriteria"

MySnap.Movefirst
while not MySnap.EOF
    myCombo.AddItem MySnap("MyField")
    MySnap.MoveNext

wend
*********************************************************************
I think that you can use this code to solve your problem.
0
 
pchahalAuthor Commented:
does this solve the formatting problem ? I need the  field columns in the list to line up as well as set the text portion to a particular field from the selection.
0
All Courses

From novice to tech pro — start learning today.