Access report not showing all images

-- -- 882 Reputation points
2022-02-09T06:18:53.477+00:00

Hi

An Access report with image control on it is not showing all images in 'Print Preview' view. A few images are missed here and there. The full paths of images are stored in a field which is bound to the image control's control source.

All image are shown in 'Report View'. However when I switch to 'Print Preview' view to print to PDF the PDF also comes up with some missing images.

I have also used below code in OnPaint for detail area but still no luck and some images are still missing.

Me.Image305.Picture = Me.PhotoPath

This technique used to work in older versions of Access but not anymore.

How can I fix the images issue?

Regards

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
843 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dory Owen 1 Reputation point
    2022-10-17T21:29:00.607+00:00

    I don't know if you solved this but I'm having an issue right now where photos taken with smartphones are over 2MB in size and render sideways (no matter how you rotate them prior to saving) or don't render at all in Access on a form.
    But cropping and saving to a size smaller than 1MB they appear just fine. I'm googling now to find out if there's a published size limit for images on Access forms (reports?). Will have to train users to crop & resize or try to at least throw a warning message if they choose a large image.

    0 comments No comments