checking count of List Box

[Guest]

Hello all,

Is there a way to see what a list box contains, kind of like a DCount
function? I am using a list box as a queue and I would like to know how many
records it contains.
I could use the DCount with the same criteria as what populates my list box,
but there is an overhead concern.

 

[ruralguy via AccessMonster.com]

Look at the ListCount property of the ListBox.

Hello all,

Is there a way to see what a list box contains, kind of like a DCount
function? I am using a list box as a queue and I would like to know how many
records it contains.
I could use the DCount with the same criteria as what populates my list box,
but there is an overhead concern.

 

[fredg]

Hello all,

Is there a way to see what a list box contains, kind of like a DCount
function? I am using a list box as a queue and I would like to know how many
records it contains.
I could use the DCount with the same criteria as what populates my list box,
but there is an overhead concern.

=ListBoxName.ListCount