Conditional Formatting

[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?

 

[John Mishefske]

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?

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