View Full Version : Change color on condition


Jon.N
03-01-2001, 03:26 AM
I have seen many examples of how to change the text colour of a field in a form on condition of say the value is >50 or the value = "Yes".

But I cannot do this in a report. Any help will be gratefully received.

Many thanks.

Mike Gurman
03-01-2001, 06:00 AM
Have a look at this topic, it's about forms, not reports, but the principle should be the same (You'll need a colour printer of course)

(It doesn't use the built-in conditional formatting feature from A2K, it's a bit different)
http://www.access-programmers.co.uk/ubb/Forum5/HTML/001051.html

Mike

Jon.N
03-01-2001, 06:24 AM
Many thanks, works a treat!