Report to PDF Problem

[mystifier]

I have reports that sometimes need images included. Unfortunately, there is no equivalent to can_grow/can_shrink with an image control to reclaim the blank space if there is no image so I have set the .width and .height in Report_Load (putting the code in Detail_Format doesn't work). My idea is to have a tiny blank image that grows when I need it.



This works, although it overlaps other controls so I have to programatically move everything below it )

The big problem I have though, is that the changes have no effect on produced PDF (DoCmd.OutputTo) which is all I am really bothered about because these get automatically sent (SendObject) to clients.

At the moment, my only solution is to have blank placeholders where images might appear which looks awful.

Any help appreciated.

[June7]

I had similar issue and finally settled for a placeholder with 'No image available' statement displaying when image is not present. I actually created a jpg of those words and that is the image linked to record. I suppose a label could serve the same.

[mystifier]

Thanks June7

Until I can find something better, ideally, making code changes to a report that actually have effect on the PDF, I have a few variations of the report with different image controls. I count how many images there are with a query and open the best suited report.

It will have to suffice for now but it is definitely a very weak area in Access.