Iff statement to show pictures

[Aamer]

Is it possible to use Iff statement to show pictures
Actually I am trying to use tow different pictures on the form if the value
is less than 0 or higher than 0



example
=IIf([Text135]<0,"","Pictue B")
=IIf([Text135]>0,"Pictue A","")


How can I Do This

so far i am unable to fix this issue



Regards

Aamer

 

[Douglas J. Steele]

You can nest IIf statements.

It's not really clear what you're trying to do, since your sample code
doesn't actually assign a value if the value is less than 0. Assuming you
want Picture B if it's less than 0, Picture A if it's greater than 0 and
nothing if it's equal to 0, you'd use

=IIf([Text135]<0,"Picture B", IIf([Text135]>0,"Pictue A",""))

 

[Duane Hookom]

First change the name of Text135 to something that makes sense.

I would have both pictures in the form and set their visible property with
code like:

Me.imgPictureA.Visible = Me.txtMakesSense < 0
Me.imgPictureB.Visible = Me.txtMakesSense > 0

You would need to call this code from the On Current and the After Update of
txtMakesSense.

 

[De Jager]

Is it possible to use Iff statement to show pictures
Actually I am trying to use tow different pictures on the form if the
value
is less than 0 or higher than 0



example
=IIf([Text135]<0,"","Pictue B")
=IIf([Text135]>0,"Pictue A","")


How can I Do This

so far i am unable to fix this issue



Regards

Aamer

 

[joelgeraldine]

l!!§!!!!!!!!