Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-10-2002, 08:44 AM   #1
bleakcabal
Junior Member
 
Join Date: Mar 2002
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
bleakcabal
Report Background

What is the easiest way to set a background for a report via programmation ?

I don't want to set it manually when I create the report because I want to user to select the background he wants in a form.

I have tried playing with the picture property by doing :
Code:
Me.Picture = "C:\Images\back1.jpg"
Or

Code:
Report_rptLitt1.Picture = " C:\Images\back1.jpg"
But I am not getting any results with both of these commands.

bleakcabal is offline   Reply With Quote
Old 04-15-2002, 03:48 AM   #2
bleakcabal
Junior Member
 
Join Date: Mar 2002
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
bleakcabal
*BUMP*
bleakcabal is offline   Reply With Quote
Old 04-15-2002, 12:28 PM   #3
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,829 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
I tried this and it seemed to work fine:

Private Sub Report_Open(Cancel As Integer)
Dim strPicName As String
strPicName = InputBox("Enter File Name", "Picture to use")
Me.Picture = strPicName
Me.PictureSizeMode = 1
End Sub

The size mode will set it to either Clip, Stretch, or Zoom (look in the helpfile for the values).

BL
hth

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 04-17-2002, 06:23 AM   #4
bleakcabal
Junior Member
 
Join Date: Mar 2002
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
bleakcabal
Yeah it worked thank you !

bleakcabal is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 03:41 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World