Conditional image in a continuous form

[Thomasso]

Hello,



I have the sales order details form below...

I have 3 icons in PNG (red, yellow, green) as indicated by the arrows. I want to display an icon based on the number in the text field (if 0, then red, if more than 0 and less than total, then yellow, if equals total, then green).

I can't seem to make this work, there is always the same icon display for all the records. Can you please help me how to achieve this?

Thank you,
Tomas

[CJ_London]

what code are you using?

[Thomasso]

what code are you using?

I thought I would use IIF in the image control source.

=IIF([Qty]=0;"/images/icon_red.png";"/images/icon_yellow.png")

(simplified)

[Gicu]

I don't think using the control source will work as that is only evaluated for the current record; you need to use conditional formatting in a control and change its font or background colors.

Cheers,

[CJ_London]

you need to include the full path - this works for me as a quick example in a continuous form - use your own formula

="D:\Dev\Images" & IIf([pwpk] Mod 2=0,"ALLogo.jpg","brushedsteel.PNG")

[Thomasso]

you need to include the full path - this works for me as a quick example in a continuous form - use your own formula

="D:\Dev\Images" & IIf([pwpk] Mod 2=0,"ALLogo.jpg","brushedsteel.PNG")

Thank you, this works!

My formula if anyone finds it helpful:

="\\srv01\ISDATEL$\graphics\icons\" & IIf([QuantityReserved]=0;"flag_0percent.png";IIf([QuantityReserved]>0 And [QuantityReserved]<[Quantity];"flag_50percent.png";IIf([QuantityReserved]=[Quantity];"flag_100percent.png";"")))

Result: