>>I am wondering what is the best approach to take when we have a listbox of type 1 - Value where we enter our own values in RowSourceType property. It's not like a listbox of type 3 - SQL where we can bound the control source to field on BoundColumn 2. Basically, what is the best approach to bound the control source when entering the values manually at the form designer level?
>
>You can only have one column when using type 1-Value.
>I prefer using type 5-array myself.
I think you can have more than 1 column. The following works:
Put a ListBox on a form. Write the following in Init():
This.AddItem("Option 1")
This.ListItem(This.ListCount,2) = "A"
This.AddItem("Option 2")
This.ListItem(This.ListCount,2) = "B"
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)