multi column combobox

M

mcnews

i can't seem to figure out how to load a multi column combo box that
is configured to use a value list.
AddItem works fine for the first column, but ItemData, NewList, List
etc don't seem to work as expected.
any clues would be appreciated.
tia,
mcnewsxp
 
D

Douglas J. Steele

How are you using AddItem?

If you've got a 3 column combo box, for example, you need to use:

Me.MyComboBox.AddItem "ValueForColumn0;ValueForColumn1;ValueForColumn2"
 
M

mcnews

How are you using AddItem?

If you've got a 3 column combo box, for example, you need to use:

Me.MyComboBox.AddItem "ValueForColumn0;ValueForColumn1;ValueForColumn2"

ah, semicolon.
i new there had to be a way.
i tried a comma.....
thanks,
mc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top