Images Displayed on Reports

S

Sandy A

Hi
I only wish to display an image in a report section if the image exists.
Sometimes there is no image, and there is a lot of whitespace that I can't
seem to get rid of within the section, as I am having to set the size of the
image control in the report design. The image control is linked to a jpg
file, the locn of which is stored in my db, so it is easy to test for the
presence of the image.

Can I do any conditional formatting within the section, that will act upon
the size of the image? I have tried to do conditional resizing, but it
resizes for all records based on the first value processed.
Cheers,
Sandy
 
G

golfinray

You should use an unbound object frame and set the cangrow and canshrink
properties to yes.
 
S

Sandy A

I was actually able to solve this myself by using the code

Me.ItemImage.Visible = Not IsNull(Me.strImageLocn)

in the Format event of the Detail section of the report.
Got help from another posting that I had missed earlier.

Thanks anyway, hope this helps someone else!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Images not shrinking 1
Shrink image frame 2
Images in Reports 1
Image error in reports. 2
Detail Format event code 1
Graphics in Report 7
Link an Image to a field 3
resize images problem 1

Top