Conditionally displaying images in reports

[spinalwiz]

I had a look around but couldnt find an answer so here goes:

I have a field in my table that stores a Microsoft Word Drawing which I want to display on my report. Only a few records actually contain a drawing, the rest are just null.

How do I display the (quite large) picture when it exists, but avoid having a huge gap in my report when it doesnt?

Thanks

 

[Crowley16]

I've not tested this myself so this might not work but:

have you tried using .visible = false when there's no picture
AND
setting the canGrow and canShrink properties

 

[spinalwiz]

Unfortunately I dont think that the bound OLE control has canGrow and canShrink properties. Also, changing the visible property would make the control invisible, but doesnt stop it from taking up a huge space on the report, resulting in a big empty gap when no picture is present.

 

[Crowley16]

then you'll probably have to have some code to dynamically resize your control then...

something like:
if isnull(value) then
picture.width = "1mm"
picture.height = "1mm"
else
picture.width = "200mm"
picture.height = "200mm"
endif

 

[spinalwiz]

Thanks, Ill try it. Any idea how to set the size of the OLE control to the size of the picture to be displayed?

 

[Crowley16]

have you tried Auto?