listbox problem

  • Thread starter Thread starter Anny
  • Start date Start date
A

Anny

Hi - I have a listbox that shows athletic categories and athlete names.

Argo 1 Taylor, Joey
Argo 1 Tyner, Sara
Argo 1 Xu, Loren
Tyro 1 Snodden, Krissa
Tyro 3 Adams, Brendon
Tyro 3 Matchum, Brant

I'd like a horizontal line to show at the end of each category. (after Xu
and Snodden, for example). Can this be done in Access? (I'm using Acc
2000)
Anny.
 
There is no automatic way to do it. It can be done by
populating the listbox in VBA instead of driving it via a
query. In the VBA code, you simply check for a category
change and write a separator to the box. Note that the
separate will occupy a row in the box and you'll have to
add code to deal with the separator being selected.
 
Back
Top