Print each page of a report multiple times

[jcstanley]

Hi

I currently have a report based on a query which creates invoices for cutomers.

What I would like to do is print each page of the report 3 times. - (Each page in the report contains details of different customers.)

If possible can the text on each copy be a different colour?

So the print order would be something like this:

Page 1 - Black
Page 1 - Red
Page 1 - Green
Page 2 - Black
Page 2 - Red
Page 2 - Green
etc...

I don't know if any of this is possible but it would be great if it can be done.

Thanks

 

[Rickster57]

reports

JC,

Take a look at this possible solution

http://groups.google.com/group/micr...b75a46e4241aa/1dab0d2b78e9ef7#1dab0d2b78e9ef7

In this case you would use forecolor instead of backcolor

 

[jcstanley]

Thanks for that. It works great with BackColor.

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Me.Section(acGroupHeader1).BackColor = Me.ColourNum

End Sub

The only thing is that you cant change BackColor to ForeColor. - There is no ForeColor option in the drop down box.

I have also tried this:

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Me.label1.Report.ForeColor = Me.ColourNum

End Sub

But it doesn't like that either.

Am I changing the right bit?

 

[Rickster57]

color

Does me.label1.forecolor=whatever work?

 

[jcstanley]

It works!!!!!!!!

Thanks for all your suggestions