Conditional Formatting

[Guest]

I have set up a couple of field (dates) that when they meet certian criteria
they change colour, ie; they change to orange a year before they run out and
then red six months before they run out, is there any way you can get them to
print out that way on a report

 

[Guest]

Have you tried the same method in your report that you used in your form?
This should be possible either using conditional formatting, or using some
VBA code. How did you accomplish this task on your form?

Perhaps this article might be helpful:

Conditional Formatting
http://www.access.qbuilt.com/html/conditional_formatting.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________