How to programatically change the Picture property at runtime

[Rob]

I want to programatically change the Picture property associated with an
Image object on a report at runtime... how and where would you do it ?

Tried On Format...
Me.imageName.Picture ="C:\image1.bmp"

But this does not work.

Thanks !

 

[freakazeud]

Hi,
have a look at this nice tutorial:
http://www.databasedev.co.uk/bound_image_report.html
HTH
Good luck

 

[Allen Browne]

Rob, if you are doing this in a form, you can crash the database by doing
that:
http://www.mvps.org/access/bugs/bugs0044.htm

Stephen Lebans has posted more info on this if you search the newsgroups for
his posts. Use the archive at groups.google.com.

 

[Stephen Lebans]

Your code will work assuming:
1) The name of the Image control is "imageName"

2) There actually is a valid Bitmap file in your C:\ drive named
"image1.bmp"

Are you sure you are using the standard Image control, not one of the OLE
Frame controls?
What is the error that is being generated?

Finally, move your code to the PRINT event of the relevant section
containing the Image control.


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Rob]

Thanks for responding...

Arghh, I had a typo... it works...

But why on PRINT and not on Format ?

 

[Stephen Lebans]

The Format event can be called multiple times which may result in a lack of
resources/memory issue.

Additionally, you need to turn off the "Loading Image" dialog that appears
as each image is loaded into the control. Use the Registry based mod here:
http://www.mvps.org/access/api/api0038.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.