[AccessD] List box populated with data and *nothing* selected

Collins, Darryl Darryl.Collins at anz.com
Sun Jan 3 22:56:58 CST 2010

Thanks Steve and Anita,

I was using Me.lbAllPrograms.rowsource = "" and then repopulating it, so
I was sort of on the right track ;)

However, both your suggestions did the trick, as did
"Me.lbAllPrograms.Selected(0) = False" which I found via google about
the same time as your emails showed up.

I ended up using "Me.lbAllPrograms = Null" as I can imagine a time when
record 0 is not the once selected and therefore will still be

Great Stuff!


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Monday, 4 January 2010 3:52 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] List box populated with data and *nothing*


This should do the trick...
Me.NameOfYourListbox = Null


From: "Collins, Darryl" <Darryl.Collins at anz.com>
Sent: Monday, January 04, 2010 5:35 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
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?

AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."

More information about the AccessD mailing list