User form single fmMultiSelectSingle listbox Value property stops working!

[TimLundSE26]

Anyone know why this should happen? For months a client has been successfully using some code using the Value property of a Listbox which is set to single selection, and suddenly it doesn't - but

Me.lstMonths.Column(Me.lstMonths.ListIndex)
​

does - lstMonths being the name of the control.

For the sale of precision, lstMonths.Value returns the empty string, and the listbox has a single column.

 

[Norie]

Tim

Sorry, do you mean they were using Me.lstMonths.Value but it's not working now but using Column does?

How exactly is the listbox being populated?

PS Isn't it Me.lstMonths.Column(0,Me.lstMonths.ListIndex)?

 

[TimLundSE26]

Yes - that is what I meant.

The listbox gets populated by the property List being assigned a single dimension array - in fact the keys of a Dictionary object, like this

Me.lstMonths.List = hMonths.Keys
​

Me.lstMonths.Column(0,Me.lstMonths.ListIndex)? Yes - thanks. There was only one element in the array, so my error will not have shown up

 

[Norie]

So you found the problem?

Was it to do with a Dictionary object, which you were using to populate the listbox?

 

[TimLundSE26]

No - I've not found the problem - but I had found a workround. I was asking as a matter of interest - building up background knowledge.