Count Items in a List Box?

[el zorro]

I have a List Box on a form. The number of entries on the list increases as
the user enrolls more attendees in a class. There is a capacity limit to the
number if attendees, so I would like the user to be able to quickly get a the
number enrolled without having to put her finger on the monitor and go " one,
two, three..."

I could write a sum query based on the query that drives the list, and show
the count in a text box on the form, I guess, but that seems a little
heavy-handed. Isn't there a slicker way to do this? Like maybe a function
that would read the list and provide a count?

Thanks!

 

[fredg]

I have a List Box on a form. The number of entries on the list increases as
the user enrolls more attendees in a class. There is a capacity limit to the
number if attendees, so I would like the user to be able to quickly get a the
number enrolled without having to put her finger on the monitor and go " one,
two, three..."

I could write a sum query based on the query that drives the list, and show
the count in a text box on the form, I guess, but that seems a little
heavy-handed. Isn't there a slicker way to do this? Like maybe a function
that would read the list and provide a count?

Thanks!

Would you believe:
=ListBoxName.Listcount

 

[el zorro]

Brilliant!

Would you believe:
=ListBoxName.Listcount