Conditional Formatting

  • Thread starter Thread starter Jennie
  • Start date Start date
J

Jennie

I have Access 97, and since this does not offer the conditional formatting
feature, I was hoping there is a way I can use code to set the formatting. I
have a report with a field CurrentCharges, I would like the font color to
change to red if this field has a value of $5,000 or greater. Is there any
way to do this?
 
Jennie said:
I have Access 97, and since this does not offer the conditional formatting
feature, I was hoping there is a way I can use code to set the formatting. I
have a report with a field CurrentCharges, I would like the font color to
change to red if this field has a value of $5,000 or greater. Is there any
way to do this?
Click to expand...


Take a look at this web page:

http://www.lebans.com/formatbycriteria.htm

--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com
 
Back
Top