Change Formatting Based on Data

[Bob Esch]

I print a report using Access 2000. The report is one page long and based on
one record.

Depending upon the data, I might change the for color or back color of a
text box, or make it invisible entirely. I do this with some code in the
report, and it works perfectly.

Now I would like to expand the use of this technique to print multiple pages
from multipe records, but change the colors or visibility depending upon the
datqa in each reord.

Is there an easy way to do this?

 

[PC Datasheet]

If you put your current code in the report's Detail Section Format event, it
should do what you want for each record.