[AccessD] Needing a Fourth Conditional Format

Darryl Collins darryl at whittleconsulting.com.au
Sun Oct 14 17:17:10 CDT 2012


Yeah, that is the 'trick' we used to use in Excel.  Set the base format as the 4th condition.  Of course this assumes you really do only have 4 conditions - and not a default 5th one (such as black text, white background).

Anyway... If the code approach offered by others works, then all this is moot anyway.

Cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Sunday, 14 October 2012 6:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Needing a Fourth Conditional Format

If you're just formatting the class status and you've used all three, could you color some other field a fourth color? It's been a long time in Access, but I'm assuming the 3-format limit is per control and not per form, right?

I'd leave the status field as is and color the class name (or some other field), when the Tentative checkbox is checked.

Susan H.


> Gotta stay with 2003 for the time being.
>
> R
>
>
> Dear List:
>
> I'm making a Gantt chart of scheduled classes for a client - an 
> interactive form where he can scroll forward and backward by a day, a 
> week, a month, or a year.  The course statuses are Scheduled, Complete 
> and Cancelled.  The bars showing the date are color coded red, green 
> and brown. And it's a continuous form.
>
> Working well.  Until...
>
> The user wants to be able to mark a course a Tentatively Scheduled 
> (reserving the space, but not yet booked).  So there's a check box on 
> the Course Schedule form for tentative.
>
> However, he wants the tentatively scheduled class to show on the chart 
> with a different color (I'd go with pink but that's not important, 
> now).
>
> It looks like I need a fourth condition but of course conditional 
> formatting only give you three conditions.
>
> I"m stumped (without redesigning the approach of the whole form - not 
> a pleasant prospect). Any ideas welcome.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list