adtp at airtelmail.in
Mon Jan 4 03:13:16 CST 2010
Darryl, As already suggested in this thread, setting the list box value to Null or its ListIndex to an unlikely value (say -1) should normally serve the purpose. However, it is occasionally observed that shadow of previous selection tends to persist (specially in multi-select scenario) after the list box has been re-populated as per revised criteria. Even non-existent rows might appear in selected state (i.e. the area where proper selection was in force earlier). In order to forestall such behavior and as an abundant precaution, de-selection by iteration through list rows could be adopted as per sample routine P_ClearListBox(), as given below. Pointer to list box object is passed as an argument. Best wishes, A.D. Tejpal ------------ ' Sample routine for absolute clearing of list box '============================== Private Sub P_ClearListBox(lbo As ListBox) Dim Cnt As Long For Cnt = 0 To lbo.ListCount - 1 lbo.Selected(Cnt) = False Next End Sub '============================== ----- Original Message ----- From: Collins, Darryl To: Access Developers discussion and problem solving Sent: Monday, January 04, 2010 10:05 Subject: [AccessD] List box populated with data and *nothing* selected Hi Folks, I am guessing not a lot of us are lurking, but here goes.... I have a form with a list box. When the form opens and the list box is initially populated, there is no record selected in the list. This is a good thing for me and how I want things to work. When the user chooses an option in the list, it will return a record set of filtered data in a different subform based on their choice. All this works swimmingly well. What I would like is a way to return the listbox to a neutral state when the users click on a reset option (which will return *all* records in the other subform). Currently the reset process works perfectly on a technical level, but on a visual level one of the list box options is always left still highlighted, which suggests that the filter is still applied on the highlighted record. I know I could use a combo box for this sort of thing (I often do), but I like the point and click simplicity of the list box approach for this form. Clearly Access is happy to have the list box exist with nothing selected as this is the default position whenever the base form is opened, however how does one return/reset it to that state? A list box populated with data and *nothing* selected? Cheers Darryl.
More information about the AccessD mailing list