[AccessD] Reports Question

Frank,

The way I do this is to make a color table that stores an image of that color
and then lookup this image based on the criteria you mentioned. You can then
place a control on the continuous form that displays this image (you can stretch
it to fit and send it to the back to make it cover the entire background).

Scott

-----Original Message-----
From: Frank Tanner III [mailto:pctech at mybellybutton.com]
Sent: Tuesday, April 15, 2003 9:07 AM
To: Database Advisors
Subject: [AccessD] Reports Question


I an writing a report that I want to color the detail
line a different color based upon an "option" checkbox
in a form.  Basically, if a box is checked AND the
criteria that the checkbox represents is present in
the record, it changes the color of that line in the
details.

For instance.  If the checkbox is "flag toll-free
numbers" and the record being displayed in the details
contains "800" "888" "866" or "877" it will color the
record green.

How can I do this?  I actually have several different
check boxes with different criteria, but I'd imagine
once one is figured out, it will work the same for all
of them.

Thank you for your assistance.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com