Coditional Formatting

[Matt]

Hi All,

I am running productivity and efficiency numbers on processors in a
processing center output to a report in access). I want to
conditionally format their ratings Red for way out of goal, orange for
within 10% of goal, and green for meeting goal or above.
Additionally, anytime a rating goes 50% or below, I want to make the
backcolor of that field yellow.

The form designer will only let me conditionally format up to 3
conditions. Is there a way in code to do more than 3.

I tried to get the value of a field by doing Me.FieldName. but value
or caption were not options in the list.

HELP!

As always, Thanks in advance!

 

[Guest]

Yes, through VBA you can basically do un unlimited number of conditional
formatting criteria.

Basically you simply need to compare the field and then using the case
statement set up you formatting.

Also, Lebans has a database which demonstrated this type of thing you should
take a look at it http://www.lebans.com/conditionalformatting.htm

I also came across the following blog (might be worth reviewing)
http://blogs.msdn.com/frice/archive/2004/06/08/151178.aspx

Daniel

 

[Guest]

Hi

Try something like

If Me.SomeField = Something Then
Me.Somefield.BackColor = vbRed
End If
If Me.SomeField = Something Then
Me.Somefield.BackColor = vbYellow
End If
If Me.SomeField = Something Then
Me.Somefield.BackColor = vbBlue
End If
If Me.SomeField = Something Then
Me.Somefield.BackColor = vbGreen
End If
If Me.SomeField = Something Then
Me.Somefield.BackColor = vbSomeOtherColor
End If

etc
etc
etc

 

[=?iso-8859-1?Q?Vladim=EDr_Cvajniga?=]

Why don't you try conditional formatting?

In Access 2002:
1) Select the text box that you want to format.
2) From the menu choose Format, Conditional formatting.

You can set more than one formatting condition.

HTH

Vlado