syntax on setting image Picture control

[cowboy]

I have an image on my report which I want to set to a file path which is saved in a field in the source table. The field with the stored file path is called Picture1. The Image is called imgPicture1



I tried;
Me!imgPicture1.Picture = Me.Picture1
Me!imgPicture1.Picture = Me!Picture1
Me!imgPicture1.Picture = Picture1
(and several other variations)

None of these worked but I made a text box and set the source value to Picture1 and then used

Me!imgPicture1.Picture = Me.txtTest.Text

and it worked haha, now is there anyway to do this without having to create a text box to get the data from the record and then set the text box to not be visible?

llkhoutx sugguested Forms!YourFormName!YourFormOleObjectControlName
which ended up Forms!DropInletForm!imgPicture1 but that also didnt work.
Thanks for help.

[Jamy]

To make llkhoutx's suggestion work you'll need the form to be open.

The best way is to have the text box with the text or hyperlink on the report (and hide it). On format event (in detail) is where the code needs to be. I even think the report needs to be in print preview to format.

However the code u used was OK, unless the picture1 is a hyperlink, then use the hyperlinkpart("name",2) to retrieve the correct text. SO:
Me!imgPicture1.Picture = Hyperlinkpart(Me.Picture1, 2)

Let me know if this works.

[cowboy]

The best I can come up with is making 8 text boxes and setting their control source to the field with the stored path and then setting the picture = to the control box. This is what I had before I did the post but I guess it will have to do, thanks for the response though.