I need to color-code a report -
i do know about conditional formatting in reports - use that all the time.

But in this case, i don't think the conditional formatting would work for me,
as it would involve a little too much work, over time.

Here's the scenario - we have "Sales Orders"
Each Sales Order number has a certain amount of tickets,
currently printed in MS-Word,  I want to the tickets via an Access Report instead.
Each Sales Order # gets a specific color
Sales Order 1234 might be pink,
Sales order 1235 might be yellow, etc etc.


anyway, i don't want to have to create a conditional formatting in a report
every time a new Sales Order number gets generated.