List Box - De-Select Item

[Sharon Hague]

Hi All

I have created a form from a table comprising of numerous list box's. Three of these list box's are set to "not required" in the table's properties.

However, I am having difficulty de-selecting the item once I have chosen one of these items from the list box in the form even though the properties in the table are set to not required.

Please advise.

 

[IMO]

Are you using the DoubleClick event of the list box? If not try

Private Sub YourListBox_DblClick(Cancel As Integer)
Me.YourListBox.Value = ""
End Sub

IMO

 

[Sharon Hague]

IMO

Your bloody good at this! - It's worked a treat

Cheers.

 

[IMO]

Glad it worked. If you need to use the DoubleClick event for something else, just create a small 'Deselect' button next to the ListBox and put the same code on the Click event of that button.

IMO

 

[Sharon Hague]

Will Do

Thanks