YOu can use Conditional Formatting with A2K or higher. FOr samples see:
http://www.lebans.com/conditionalformatting.htm
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.
Verrsion 1.8
Starting to cleanup code and add comments!
Version 1.4
First release
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
