Wortz, Charles
CWortz at tea.state.tx.us
Tue Apr 15 08:21:29 CDT 2003
Frank, If you have a 21st Century version of Access, then use Conditional Formatting. If you have a 20th Century version of Access look in the archives for workarounds. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Frank Tanner III [mailto:pctech at mybellybutton.com] Sent: Tuesday 2003 Apr 15 08:07 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.