Turning Red…

[JWT]

Change Print Color If Less Then Zero.
Working with Access97 and company is upgrading to Office2000.
I would like to have the color change to red if the amount is <=0. Can this be set to view and print red for zero or less but black if >=1? Would Office2000 let me run this type of report?

Can someone talk me through this...Thank you, JWT?

 

[Graham T]

JWT

In Access 2000 you can use conditional formatting to do this for you.

Select the control you wish to apply the format to and from the formatting menu apply the condition and the text or background colour.

HTH

Graham