Reports

[Guest]

I have an Access database with 1 table. Apart from the normal text fields, I
have a text field that has the filename of an image in a directory. E.g.
image.jpg.

What I want to do is create a Report, so that the image is displayed using a
manually coded path to the image, e.g. C:\pictures\new\<<imagename field>>

Can someone help me by showing me that to do?

thanks.

 

[SA]

SKC:

This is fairly simple to do.

1.) Add your path field to the report's underlying query.
2.) Add an Image control to the report and select any image to start with.
3.) Add the path field to the same section of the report where the image
control is and set the path control's visible property to false.
4.) In the On Print event of the report section that contains the image
control add code like this:

If len(Me!NameOfYourPathControl.Value) > 0 Then
Me.NameofTheImageControl.Picture = Me!NameOfYourPathControl.Value
End if