[AccessD] Reports Question

Frank Tanner III pctech at mybellybutton.com
Tue Apr 15 08:06:55 CDT 2003


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.


More information about the AccessD mailing list