listbox row colours

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top