listbox row colours

P

polisci grad

Is it possible to have rows alternate between grey and white in a listbox?
 
S

Stephen Lebans

It's not possible. Use a Form instead set to Continuous view, created to
resemble A Listbox control, and then apply Conditional Formatting to achieve
the desired effect. I think Arvin has a sample on his site...let's look.
It's the SubForm Demo 2K here:
http://www.datastrat.com/Download2.html


There are two sample MDB's on my site demonstrating how to achieve alternate
row coloring:
http://www.lebans.com/alternatecolordetailsection.htm
AlternateColorDetailSection.zip is a class to allow for alternate bands of
color for Forms in Continuous View.


OR


http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!

New Feb 08,2002. Added support for Datasheet view and SubForms.

A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet View

Version 2.7

Added sample demonstrating how to achieve a background Hover/Highlighting of
rows for a form in Continuous view.

Version 2.3

Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.

Version 1.9

Added sample form to show how to apply conditional formatting to based on a
Boolean(Yes/No) field.
--

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

polisci grad

Right on, will try...too bad about the list box, it seems to be easier for me
to display a crosstab query in a listbox since the subform always shows
'#Name?' when no data exists.

oh well
 
Top