[AccessD] Needing a Fourth Conditional Format

Rocky Smolin rockysmolin at bchacc.com
Sat Oct 13 15:06:16 CDT 2012


For the moment I have added (tent) after the class name which prints under
the colored bar indicating the start and end of the class to indicate
tentative scheduling. It's the same color as a non-tentative scheduled class
so he may want some other visual cue that it's tentative.  

Let's see how the user likes it.

Your idea might work - the scheduled class is in red - I could conditionally
format the back color of the class info of a tentative class in pink.

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Saturday, October 13, 2012 12:59 PM
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