Conditional Color Formatting Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to do some conditional formatting in Access 97. What I need to do is to change the back color of a control to light GREEN if the the value of the control is equal to or greater then 95 or have the back color change to ORANGE if the value is less than 95

I know that is a cake walk in Access 2000, 2002 and XP, but, how can I do the same in Access 97? Need some suggestions and code examples. Thanks.
 
Check out http://www.mvps.org/access/forms/frm0024.htm at "The Access Web"
and see whether it meets your needs.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Russ said:
I need to do some conditional formatting in Access 97. What I need to do
Click to expand...
is to change the back color of a control to light GREEN if the the value of
the control is equal to or greater then 95 or have the back color change to
ORANGE if the value is less than 95.
I know that is a cake walk in Access 2000, 2002 and XP, but, how can I do
Click to expand...
the same in Access 97? Need some suggestions and code examples. Thanks.
 
I need to do some conditional formatting in Access 97. What I need
to do is to change the back color of a control to light GREEN if
the the value of the control is equal to or greater then 95 or have
the back color change to ORANGE if the value is less than 95.

I know that is a cake walk in Access 2000, 2002 and XP, but, how
can I do the same in Access 97? Need some suggestions and code
examples. Thanks.
Click to expand...

Since this is posted in a Report's newsgroup, I'll assume this is for
a report, not a form.

Code the Report Section Format event that the Control is placed in
(Detail?):

If [SomeControl] >= 95 Then
[SomeControl].BackColor = vbGreen
Else
[SomeControl].BackColor = 52479
End If

Change color values as needed
 
Back
Top