[AccessD] Needing a Fourth Conditional Format

Doug Steele dbdoug at gmail.com
Sat Oct 13 10:51:30 CDT 2012


Further note:  If I remember correctly, if you do build the conditions
manually using the wizard, you can then view them and change them in code.

Doug

On Sat, Oct 13, 2012 at 8:49 AM, Doug Steele <dbdoug at gmail.com> wrote:

> Without trying it, my guess is that if three conditions work when you
> create them manually, four conditions should work if you build them in
> code.  Shouldn't take long to build a simple test.
>
> Doug
>
>
> On Sat, Oct 13, 2012 at 8:46 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:
>
>> Doug:
>>
>> Not sure this will work for a continuous form where a control (text box)
>> changes backcolor depending on its value in that record.
>>
>> What do you think?
>>
>> Rocky
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
>> Sent: Saturday, October 13, 2012 8:38 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Needing a Fourth Conditional Format
>>
>> Hi Rocky:
>>
>> You can build format conditions in code; I think there isn't a limit of
>> three.  Here's a sample I use from a Form_Load event:
>>
>>   txMargin1.FormatConditions.Delete
>>   txMargin1.FormatConditions.Add acExpression, , "[txMargin1] <> 0 and
>> [txMargin1] < " & MarginPct1
>>   txMargin1.FormatConditions(0).BackColor = 255 'red
>>   txMargin1.FormatConditions.Add acExpression, , "[txMargin1] <> 0 and
>> [txMargin1] < " & MarginPct2
>>   txMargin1.FormatConditions(1).BackColor = 33023 'orange
>>
>> This article shows an example with 4 conditions:
>> http://msdn.microsoft.com/en-us/library/office/aa139965(v=office.10).aspx
>>
>> I used code because I had a ton of fields in a form, all with identical
>> format conditions, and it is WAY easier to modify code than laboriously
>> work
>> your way through the wizard for each field.  In the example above, the
>> client wanted colouring depending on an adjustable profit margin.
>>
>> Doug
>>
>>
>> On Sat, Oct 13, 2012 at 8:23 AM, Rocky Smolin <rockysmolin at bchacc.com
>> >wrote:
>>
>> > 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.
>> >
>> > MTIA
>> >
>> > Rocky Smolin
>> > Beach Access Software
>> > 858-259-4334
>> > www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
>> > <http://www.e-z-mrp.com/>
>> > Skype: rocky.smolin
>> >
>> > --
>> > 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
>>
>> --
>> 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