[AccessD] Reports Question

Frank
Your question appears to be about reports. If so you can just write a
Case statement in the OnFormat of the Detail which tests any value you
like and sets the BackColor property of the detail section. The ADH has
an example of doing this type of thing although it's specifically for
alternating shaded and clear lines. Principle's the same though. 

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Frank Tanner III
> Sent: 15 April 2003 14: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.
> 
> Thank you for your assistance. 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
>