>Dear all,
>
>In a Chemical labelling system:-
>
>A chemical may have 1, 2 or none harzardous remark:-
>
>The harzards are marked at the fields har1, har2 which is 1 character long. If the field is null, no harzards. if say "C" - corrosive; "H" - harmful etc.
>
>In the label report, how can I referencing the fields har1 and har2 runtimely? to add the correponding warning labels at the label report, say if har1="C"; a corrosive sign will print the label and etc.... How can I archieve for ??
If the total number of images is quite small (for example, less than 15) then you could add many
Image/ActiveX Bound Control's to your report - 1 for each image.
Place these all on top of each other.
In the
Print When... dialog enter har1="C" etc. in the
Print only when expression is true field.
If you have a large number of images, you might want to try using only one image control, and use a dynamic picture source (maybe a macro substitution, though I am not sure this is possible), or use a static file name for the picture source and overwrite the file with the desired image for each label (by calling a UDF). This will probably mean that you will need to use the appropriate CLEAR command, because VFP caches the image.
censored.