Access 97 conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a continuous form in Access 97 with several fields including a date
field. I would like to show any record with today's date in a different
forecolor. Is this possible without having the conditional formatting
facility in Access 2000 and later?
Thanks.
 
That solution uses CF and is only for A2K or higher.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
If you REALLY REALLY want it, create a query with a second set of fields:
calculate all the fields so that one set is null on today's date, and the
other set is Not Null on today's date. Add a second set of controls to your
form, bound to the second set of fields. set the forecolor for each set of
controls, set all controls to transparent, and place the second set on top
of the first set. Now one set of controls (with forecolor 'A') will be blank
on today's date, and the other set (with forecolor 'B') will be blank on
other dates.

(david)
 
Back
Top