A Picture Is Worth a Thousand Words
Continuing in Access, set the Photo’s data type to Memo. I’ll explain why in a moment. Close the design view window, saying Yes to save changes. Back at the main Access window, double-click the movies item. As shown in Figure 8, the new Photo field is now shown.
I previously indicated OLE as a possibility. If you want to use an Access report, OLE is indeed a good possibility. Dragging a picture into an OLE Object field will allow that picture to display in an Access report (for example, dragging from a browser or from Windows Explorer).
Using an OLE object does not, however, allow the picture to display in a Word mail merge document that uses the Access database. Nor will using a hyperlink object within Access. In fact, the latter does not display the picture in Access or Word.
Instead, to get a web-based picture to display in Word, we have to use a little sleight of hand. We have to construct something that presents the picture link itself as [pseudo] regular text in Word. To do that, we can use either a text field or a memo field in Access. And because some web links can be very long, I decided to use a memo field.