listbox problem

[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.

 

[Douglas J. Steele]

Not in a listbox.

 

[Stephen Lebans]

You can, "somewhat", Doug.
http://www.lebans.com/DownloadFiles/CboRowSeperators.zip
CboRowSeperator.zip is a database containing a functions to display non
selectable Row dividers in a Combo.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Alvin]

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.