Show an image when yes/no of a record is true (1 Viewer)

[D4Mozzy]

Hi,

I am looking for a solution that allows me to show an image in a report if a yes/no of a record is true

For example:

My database contains chemical samples, in the record it specifies of the chemical is flamable or not with a yes/no tickbox.

When it is set to yes I want to show a warning symbol showing that the product is flamable.

I'm rather new to programming in access, probably missing something very simple here

 

[Ranman256]

make an image table, tImages:
setting (string)
image (OLE)

the data would be:
flammable , flame image
Non flammable, red circle line thru it image

then make a query on your data, qsData, add the field:
Setting: IIF([IsFlammable],'flammable','non flammable')

make another query to add the images
this query uses the query qsData and table tImages
join the two on the field SETTING.

now you get images with the setting.