Hi all

I have created a listbox in a userform which the user can double click on to drill down in to the detail behind their chosen record.
Noramlly the list will contain hundreds on records so the listbox window I have created fills most of the screen. I am happy with this view and I have provided tools on the form that can filter and sort the displayed list so that the user is not overwhelmed. So far, so good.

My problem is that when the list has been filtered down to only a few remaining items (e.g. 3) then most of the bottom area of the list box area will be blank. Now when they single click on a record, that record becomes highlighted. If they then double click in the blank area at the bottom of the listbox below the few remaining filtered items, the highlighted item is used in the beforedoubleclick event. This might not be what was intended.

I would prefer that clicking in the blank area of the listbox deselects the previously selected record (using .listindex = -1 perhaps) so that my existing code can ignore this kind of double click.
How can i deselect the item when the user double clicks in the blank area? Is this possible or should I just avoid this approach by perhaps using a button below the listbox to drill down instead?

Many thanks in advance for you help on this...

Use a button or perhaps post this in the appropriate forum as this forum is for Visual Basic 6.0 and not .NET



Good Luck

Hi

It would be really good if you can filter the blank records before they are loaded to Listbox probably by a where clause in query etc

If it can;t be done, you can check for the selected text and delete the record. But it is a tedious process

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi
I am using VBA (VB6.5) to run these user forms within Excel but I suspect you are right and that I am forced in to using a button.
The only other alternative I could come up with is to resize the listbox to be smaller so that the empty space isn't displayed, thereby doing away with the problem. However, that would make the rest of the form look weirdly empty and I don't want to have to resize the whole form as there are too many other controls on it to worry about.
I think I'll do as you say and stick with the button.