Conditional formatting

[Herb Wexler]

I am having trouble getting conditional formatting to do what I want. I
select the control and then click on the Conditional button on the ribbon and
enter the expression. Is there a way to see the generated code?

Basically I want the color of one control to change based on the value of
another control.

Is there a way to use VB code to accomplish bypassing the Conditional
button?

 

[Daniel Pineault]

To my knowledge there is no way to see what Access has done to create your
conditional formatting. That said, I have used CF in numerous case just like
yours and it works quite nicely.

But to answer your secondary question, Yes, you can use vba to create your
own custom conditional formatting routine. What I'd suggest is that you
create a sub or function, depending on your needs, that does all your
formatting logic... then call it as req'd. In this case,you'll need to call
it in the 'current' event of the form so when you move to another record the
formatting is right and also in the afterupdate event of each control that
impacts your conditional formatting.

FYI, you can change the color of a color, or even a form section, by using
the .BackColor = RGB(0, 0, 255)... Simply change the RGB values to get the
desired color.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Linq Adams via AccessMonster.com]

In this case,you'll need to call it in the 'current' event of the form so when you >move to another record the formatting is right and also in the afterupdate event of >each control that impacts your conditional formatting.

You have to remember that doing most formatting tasks this way ***will only
work for Single View*** forms. In Datasheet and Continuous View forms, ***all
instances of a control*** on ***all records*** will be formatted according to
the value of the current record.

In other words, if a Due Date turns red when it becomes past due, and the Due
Date on the current record is past due, ***all Due Dates*** in ***all
records*** will turn red in all form views except Single View forms.

 

[Herb Wexler]

I'm experimenting with Access 2007. I create two forms for the same table.
One form shows one record on the form the other is a split form. Based on the
value of a Yes/No check box I want another field to turn red. It works fine
on the regular form but does not work on the split form.

Is this a limitation of the Conditional Formatting button?