When I originally set up our system reports, I used various colors on some of the headers/footers, boxes around totals, etc....
Now that a "network" color printer has been put into place, the boss has decided that, (rightly so), it is too expensive to print all the reports out in color now. My question.... Is there a way to do a Mass Property change on the whole report to make the foreground color "0" black?? I really dread having to disect each line, field, etc. to do this....

Thanks in advance for your help....
Desperate (and lazy) Dave

Lazy Dave,

Here's a lazy answer... (depends on how many reports you have)

How about opening each report in design mode and pressing Ctrl-A to select all the objects.

Then click on the icon for 'Font/Fore Color' on the tool bar and choose 'black', this will do all the lables and text boxes

Then click on the icon for 'Line/Border Color' on the tool bar and choose 'black', this will do all the lines.

Alternatively you could right some VBA which will loop throught all the reports and all the objects and set the colours, but this might take longer :) .

Hope this helps a bit


Brett

Thanks so much for the quick response!!!! This forum has never failed me yet!!!

You all are awesome....

Dave