[AccessD] Needing a Fourth Conditional Format

Rocky Smolin rockysmolin at bchacc.com
Sun Oct 14 17:31:14 CDT 2012


Well, now that you say it that way, there is a fifth which is transparent
background, IOW no class scheduled for that day.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Sunday, October 14, 2012 3:17 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Needing a Fourth Conditional Format

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



--
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