Printable View
Im currently converting VB.ComboBox to MSForms.ComboBox due to unicode issue.
Is there anyway to imitate the following code?
MSForms.ComboBox doesn't support .ItemData and .NewIndex anymore.Code:cmb.ItemData(cmb.NewIndex) = 0
I'm greatly appreciate for responses
you could try using a hidden column in the combobox as forms2 combo support multi column
Are you are aware that MS Forms 2.0 are not redistributable?
Darn, I don't have a ComboBox control yet that I could advertise! :D Anyways, there is atleast one freely usable Unicode ComboBox control at Planet Source Code. If you're looking for other controls, I have a textbox, listbox and a label done, but they're not final/stable releases yet.
The advantage over Forms 2.0 is that the syntax is compatible and the controls are freely distributable/usable.
I do aware of MS Forms 2.0 is not redistributable.
The application comes along with microsoft office so its not a problem at all :)
I use multiple column approach, it works!
the .TextColumn is for which column to be displayed in selected listCode:cmb.BoundColumn = 1
cmb.ColumnCount = 2
cmb.TextColumn = 1
cmb.Column(1, cmb.ListCount - 1) = 0
But i got another issue which is to show only 1 column in populated combobox.
I can find any column hide function for that. Any idea?
make the width of the first column the width of the combo
Found the solution :)
Works like charm! Thanks guysCode:cmb.ColumnWidths = "450pt;0pt"
Thread moved
Sounds like you are doing this in Access VBA anyways so the end user will need Access installed at a minimium.
Ps, dont forget to Resolve your thread from the Thread Tools menu so others know your question has been answered. ;)