Displaying Pictures in a report

[Marcus_416]

Hi I am trying to figure out how to display pictures in a specific way in a report.

This is a merchandising floor plan report
My query creates a list of product records that each have a specific floor plan placement ID# i.e.
Product#1 (1201), PlacementID# (5), Picture(1201.bmp)

The issue is that in the report design I can only figure out how to have this come out as a list of values.

I have tried to create a quey that has a placement table of values liked ot the product table but it becomes too complex as there are over 160 floor placements on my floor plan.

My question: Is there a way to set an Unbound Object Frame(s) in the correct position(s) on the report, and to have the Value of the Unbound Object Frame(s) = PlacementID# in the query.

something to the effect of... Me.Unbound Object Frame #5 Value is = PlacementID#(5), Picture(1201.bmp)

This way I could set up a pic frame for each position on the report and have the report look up pic values from the query.

Advice pls.

 

[Max D]

If you are working with Access 2007, you can use regular Image control. If you bind it to the field or expression that is a picture path and filename, it will display that picture.