Change Report Label background to 1 of 6 backgrounds.

[cw via AccessMonster.com]

I have a database of names, team color, image pathname used to generate 3x5
labels (up to 6 per sheet).
I then have a Form that opens & shows all the names in the database with a
"Selected" checkbox by each one. This allows me a choice of which 3x5 labels
to print. (for ex.. 2 red team, 2 blue & 1 yellow team.

The labels print off on standard white photo paper, and the "image
backgrounds" need to print behind the proper label.

Problem is, I can't make the background of each label to change to it's
proper "background image" depending on it's team color? (I'm using 6
specially designed colored images stored in a folder for each team)

I know how to use a single "static image" for all labels but not sure how to
make the image background change at report runtime.

Currently my report is printing the selected mix of team labels, but the
backgrounds are all white.(no background image selected at all) I use this
code to print the persons picture: (txtStockGraph is the image pathname from
my table)

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.Image11.Picture = Me.txtStockGraph
End Sub

I thought about storing the background images as paths also in a table.
Could I use a Case statement to call the correct background?

Thanks for your help,
cw

 

[jalexander via AccessMonster.com]

After reading Stephen Lebans Transparency ideas, I still have not been able
to get anywhere on this. I read one idea about loading all 6 images & setting
them invisible, then turning on just the one that matches the Team color
label?

Any other ideas?
Thanks in advance,
cw

 

[cw via AccessMonster.com]

While I was able to get this code to work fine to change the BACKGROUND color
of each label.

Question :

How do I alter this code to use IMAGES instead of BACKCOLOR's ?
(I have the images stored as links in my table)

----------------------------------------------------
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Select Case Me.kidsTeamColor
Case Is = "Green"
Me.Detail.BackColor = 65280
Case Is = "Purple"
Me.Detail.BackColor = 13959381
Case Is = "Red"
Me.Detail.BackColor = 255
Case Is = "Yellow"
Me.Detail.BackColor = 8454143
Case Is = "Blue"
Me.Detail.BackColor = 16711680
Case Is = "Orange"
Me.Detail.BackColor = 33023
Case Else
Me.Detail.BackColor = vbWhite
End Select
End Sub
----------------------------------------------

Thanks for any help,
cw

After reading Stephen Lebans Transparency ideas, I still have not been able
to get anywhere on this. I read one idea about loading all 6 images & setting
them invisible, then turning on just the one that matches the Team color
label?

Any other ideas?
Thanks in advance,
cw

I have a database of names, team color, image pathname used to generate 3x5
labels (up to 6 per sheet).

[quoted text clipped - 26 lines]

Thanks for your help,
cw