I would like to include some icons in my report.
Here’s a simplified version of what I’m trying to achieve, so far without success:
tblAnimals
Category
Breed
Quantity Bird Parrot 2 Mammal Hamster 12 Reptile Lizard 5 Bird Budgie 9 Mammal Rabbit 5
On my report I want to replace the “Category” textfield with a suitable icon; a small picture of a bird, mammal or reptile.
If at all possible I want to store the icons within thedatabase (eg in a table with CategoryName and CategoryPic fields); they won’t take up much space and Idon’t want to be referencing externalfiles as this adds complexity when the database is packaged up and distributedto users around the organization.
I tried adding them to the image gallery in a dummy form butmy report did not display the icons, just an empty box.
I also tried using a table with an OLE Object field but this only displays on the report as a placeholder with the name of the icon file.
What would be the most effective way of storing, referencing and displaying these icons?