[AccessD] Clear item from listbox

Susan, much easier:

 Me.lst_TRANS_NO.Value = Null

D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Monday, December 15, 2003 1:11 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Clear item from listbox


Requerying the listbox didn't clear the selections?  Anyhow, if you want
to clear the selections one at a time, you would use:

Me.lst_TRANS_NO.ItemsSelected(intI) = False


Charlotte Foust

-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu] 
Sent: Monday, December 15, 2003 12:37 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Clear item from listbox


Charlotte,

I'm trying to implement your suggestion. Here's what I've got. Something
is definitely not right:

     Dim intI As Integer
     For intI = 0 To Me.lst_TRANS_NO.ItemsSelected.Count - 1
     Me.lst_TRANS_NO.ItemsSelected = False
     Next intI

What am I doing wrong?

--Susan


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Monday, December 08, 2003 10:40 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Clear item from listbox


Are you trying to do this in Access or in the stored procedure?  In
Access, you can loop through the listbox's itemsselected collection and
set each item's Selected property to false.  If you're just seeing a
marquee around the item rather than reverse video showing it is
selected, then I can't help.  I've never figured out how to get rid of
that either.

Charlotte Foust

-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu] 
Sent: Monday, December 08, 2003 8:32 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Clear item from listbox


I have a listbox and I want to clear all items selected in it.  To do
that, I am executing a stored procedure.  But, even when I've done that,
the first row in the listbox remains selected.  Is there any code that
will unselect all items in a list box?  I'm in an adp in Access XP.

--Susan


Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com