[AccessD] Reports Question

>From what I can tell, the conditional formatting only
works with the field of the record detail that it is
applied to.  I need it to be applied to the entire
record detail line.  I am using MS Access 2000.

The checkboxes themselves won't be visible on the
report.  The detail section has (visible) Date, Time,
Call Type, Dialed Number, Extension, and Duration. 
Based upon the checkboxes (Local Number, Excessive
Length, Repetative Call, etc), I want it to color the
entire detail line.

--- "Wortz, Charles" <CWortz at tea.state.tx.us> wrote:
> 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.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com