change color in one record without changing others

  • Thread starter Thread starter eecalta
  • Start date Start date
E

eecalta

I've set up a database for a scheduling program in a manufacturing
environment that pulls all the information I need into reports for front
office, however I would like to "color code" certain records in a report
based on the status of the work in progress without affecting other records
that the criteria doesn't apply to. Is this possible?
 
eecalta said:
I've set up a database for a scheduling program in a manufacturing
environment that pulls all the information I need into reports for front
office, however I would like to "color code" certain records in a report
based on the status of the work in progress without affecting other records
that the criteria doesn't apply to. Is this possible?
Click to expand...


Sure. Check the Conditional Formatting item on the Format
menu (when the report is open in design view).

If that's not sufficient for whatever your specific needs
are, then VBA code can be used to do all kinds of things.
 
Back
Top