Formatting ListBox results

  • Thread starter Thread starter Pat Whitted
  • Start date Start date
P

Pat Whitted

In Access2003 I have a listbox control that displays resources
associated with a project ID. This list is sorted by Week, Role, and
Name. I have been requested to have a line drawn under the last entry
for any given week, providing a visual break between the weeks. I know
I could accomplish this if I created a report based on the same values
and made it a sub to the form, but I need to be able to select and
interact with the items in the listbox. I've looked at both Lebans'
site, and Access Web, but haven't found anything there that would
help. Lebans has some code that alternates the color on every other
line, and there's code for adding line numbering, but nothing for
formatting based on "grouping" in a listbox. TIAFAH! - Pat
 
Limited formatting is available by:

1) Selecting a different horizontal justification for specific rows:
http://www.lebans.com/commandbars.htm

2) Adding extra SPACE or "*" chars for instance to visually seperate a
row or rows.
http://www.lebans.com/justicombo.htm

3) Adding blank spaces between rows to signify groupings:
http://www.lebans.com/DownloadFiles/CboRowSeperators.zip

But as you said, there is nothing on my site to help you with this
issue.<grin>
:-)
--

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

Thanks for your reply! I was aware of a couple items on your site that
could point me in the right direction. I had thought that either the
code for alternating row colors in a listbox or adding rownumbers in a
listbox would get me pointed down the right path. For now, I've added
this feature request to the "nice to have" list, and will revisit it
(and your site) later. Thanks again! - Pat
 
Back
Top