VBA and BLOB images? Access 2016

[wrightyrx7]

Hi all,

I think my database is being bloated by images. I have done some research on how to avoid this, and have followed some instructions on creating a table with the paths to the images.

I have inserted an object frame and created the table but dont know what to do now....

The instructions online show how to do it in older versions of Access. I am using 2016 and some of the fields in the tutorials (property sheet) are not in 2016.

Please can someone help.

Thanks
Chris

 

[Ranman256]

In the form ,ON CURRENT event,
Image.picture = txtPath

The image will change with the record.
The text box, txtPath is the field holding the path name.

 

[wrightyrx7]

In the form ,ON CURRENT event,
Image.picture = txtPath

The image will change with the record.
The text box, txtPath is the field holding the path name.

This worked, thank you