Change color on condition (1 Viewer)

[Jon.N]

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.

 

[Atomic Shrimp]

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]

Many thanks, works a treat!