change background of report at runtime

groengoen

Registered User.
Local time
Today, 06:06
Joined
Oct 22, 2005
Messages
141
I have reports which have jpeg backgrounds, which are standard forms (colored). I want to give the user the option of printing that background form, or , if he/she wants to put standard forms into the printer, print with no background (i.e. blank background). This would economise on ink if the printed forms are available. Is it possible to set the background property in VBA?
 
I actually discovered how to do it using the following bit of code:

If rst1("RptPic") = True Then
Me.Picture = ""
Else
Me.Picture = "C:\Program Files\Medical Insurance\vhi1.jpg"

End If
 

Users who are viewing this thread

Back
Top Bottom