Clear selection(s) in a listbox

[batteam]

I usually clear selections in my listbox by using the following: With lstxx
For intI = 0 to .ListCount -1
.Selected(intI) = False
next intI
end With

However this little code does not work when the multi-select property of the listbox is 'None'.

Anybody have another neat lettle way to clear any selections in a listbox with the with the Multi-select set to None? Thanks for your help.

 

[PWise]

me.controlname=null

 

[dhookom]

I use Allen Browne's ClearList() and SelectAll() functions

Duane
Hook'D on Access
MS Access MVP

 

[batteam]

That would do it. Thanks for the tips.

 

[missinglinq]

FYI, PWise, as I'm sure you know,

me.controlname=null

actually means

me.controlname.Value = null

and a Listbox, set to Multi-select, as in this case, no longer has the Value Property.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[PWise]

The Missinglinq:

However this little code does not work when the multi-select property of the listbox is 'None'.

So now if the multi-select property is set to NONE
then

listBox.CouldHaveValue=True

 

[PWise]

BTW have you ever tried to set a multiselect listbox to null