Gustav Brock
gustav at cactus.dk
Mon May 26 10:31:19 CDT 2003
Hi Arthur
> Love this list! A dozen solutions in a few minutes! Makes me look like I
> know what I'm doing :-) My rates are high because I'm an army of coders....
Hey, they all forgot to watch for the property ColumnHeads which adds
one to ListCount and removes ListIndex 0 from your list of usable list
values.
I use Abs(lst.ColumnHeads) to compensate for this like:
With Me.List0
For x = Abs(.ColumnHeads) To .ListCount - 1
.Selected(x) = True
Next x
End With
Yes, I know you "never" use column heads ...
/gustav
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bruce Bruen
> Sent: May 26, 2003 10:10 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Listbox question
> Dim x As Integer
> With Me.List0
> For x = 1 To .ListCount
> .Selected(x - 1) = True
> Next x
> End With