Insert picture on Report based on field name

[ghloid]

Well, I guess that's the best way to explain what I want. I've been searching, and I can't seem to find any other references to this.

What I need to do is create a report with some sort of link to a GIF saved on our network. The GIF name will change with every record of the query that the report is tied to. This will be used to print file labels for our office. So, if you have a person with a last name of "Azon" or something, I'm trying to make a label report that will print the name (easy), then put a GIF picture of the letter A (we have 26 predefined pictures created already) and then the GIF of the letter Z. There are different GIF's for each letter of the alphabet, so we're looking at 26 different possibilities. Too many for any type of conditional formating (if we were to forgo the GIF route).

Anyway, I think that explains it. I'll design a query to get the right file name of each GIF for for record. That is the easy part. How do I insert that onto a report then, that when the report is opened, it has the right GIF's for each record on the report? This will be done in batch, so there will be many labels printed at once ranging from all the letters in the alphabet.

Sounds like this could be really easy (and I'm not seeing it), or incredibly impossible.

If anyone has any ideas, please let me know.

THANKS!

 

[FancyPrairie]

Try inserting a picture on your report. Then in the OnFormat event of the Details section, change the Picture property of the picture to point to the path of the gif file you want.

 

[ghloid]

Wow, you're quick!!! I did some more searching and found more references to this. I must not have been using the right search criteria, because now I'm finding oodles.

Anyway, here's the thread of what looks like a good explanation (in case anyone else is wondering). It's based on your idea:

thread702-289543

I think this will work. Seems to be pretty simple.

THANKS!!!!