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.