Unselect Listbox Entry?

[kashif73]

Hi ,

I have a combobox in my form. If the user select some option from the combobox, it subsequently populate Listboxes (5 in all) on my form. This works fine. the annoying part is that in Listboxes all the populated entries gets highlighted & when ever I print that form all the list boxes have that black color for the populated entries. Is there a way that I cna get rid of this highlighted thing in listbox. Please know that all the listboxes are bound to selection of my combobox. Thanks.

Kashif
form.jpg

[ADezii]

@kashif73
To deselect all selected items in all List Boxes on a Form, try:

Dim ctl As Control
Dim intCurrentRow As Integer
 
For Each ctl In Me.Controls
  If ctl.ControlType = acListBox Then
    For intCurrentRow = 0 To ctl.ListCount - 1
      ctl.Selected(intCurrentRow) = False
    Next
  End If
Next

[kashif73]

Thxs ADezii. It helped :)

[ADezii]

@kashif73
You are quite welcome, kashif73.

[NeoPa]

Simple question :
Do you really want your data shown in ListBoxes? It seems that TextBoxes may be more appropriate.

I don't know the whole story of course, so only you can answer that.