>Hey FoxFolx!

>Have a client who DESPERATELY wants to keep using Colored paper for each different copy of an Invoice. Doesn't want to go the DotMatrix multi-form route. I know there is paper that can be bought interleafed in color, but it's too 'iffy' (in case the paper jams).
>
>Has anyone figured out ANY routine for ANY printer where the different copies can be fired to a different paper tray on the printer? (Would need a multi-trayed printer, obviously). We're ready to require a specific printer-- if the solution can be found.
>

John,

I haven't tired this but... off the top of my head...

This would require hard coding escape codes... or, you could set up a table of escape codes for different printers but.

1. Find the escape code that sets the printer to tray1, tray2, tray3.

2. Create a cursor or table for the invoice report that had three records for each invoice.

3. In each of the three records have a field to hold the escape code... sort of like...

Customer    Invoice Num      Color
100           10              White 
100           10              Pink
100           10              Canary
100           23              White
100           24              Pink
100           24              Canary

...etc. Then have a field on the top of your report that puts on the escape code.

BOb