Item Value Not Displaying

Ok, I figured it out using Column.EditOptions.

However, if I add a constraint to the column such as:

Column.EditOptions.Constraints.Add "Employee Name 1", 1
Column.EditOptions.Constraints.Add "Employee Name 2", 2

How do I get to the data value?  If I use the ValueChanged event to display the caption and value it is returning "Employee Name 2" as the value and empty string as the caption.  I expected it to return 2 as the value and "Employee Name 2" as the caption.

I must be missing something.

Help!

Thanks

So how do I know that the user clicked on the first item?  I need to return the value and caption of the item that the user clicks on in the combo.

Nope.  Item.Value is returning "Employee Name 2" (if I click on that item).  So if I use Item.Value in Column.EditOptions.Constraints(Item.Value).Caption then I get a type mismatch.

Ok, we're getting there.  I had to set .Constraint.Edit = True and then manually set the caption for each row but that part works.

However, the task example does return what you would expect but only because the data values happen to be the same as the order that they were placed in the combo.  Try switching the first 2 items:

    Column.EditOptions.Constraints.Add "In Progress", taskStatusInProgress
    Column.EditOptions.Constraints.Add "Not Started", taskStatusNotStarted

Then when you check the value and caption using:

MsgBox "Value: " & Item.Value & " Caption: " & Column.EditOptions.Constraints(Item.Value).Caption

in the valuechanged event, the first to items will return incorrect captions.

So is there any way that this can be "fixed" in 10.3.1?  It seems like common sense to have a combo act like the regular VB combobox with itemdata.