[AccessD] Reports Question

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.


More information about the AccessD mailing list