IIF CONDITION

How to show or hide an image or a text box connected to a iif condition
???

iif(number=0;image A;imageB)


Thanks - Ciao !


Roberto

Not sure how you are doing this but you need commas instead of
semicolons in the IIf statement.

Not sure where you are doing this, seems a macro?

If not, I use the following code in a form and report to set visible text
boxes and comments.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Tool_CostGBP 0 Then
Me.Tool_CostGBP.Visible = True
Me.Tool_CostEuro.Visible = False
Me.Tool_CostDollar.Visible = False
Me.TxtToolingAvail.Visible = False
Else
If Me.Tool_CostEuro 0 Then
Me.Tool_CostEuro.Visible = True
Me.Tool_CostDollar.Visible = False
Me.Tool_CostGBP.Visible = False
Me.TxtToolingAvail.Visible = False
Else
If Me.Tool_CostDollar 0 Then
Me.Tool_CostDollar.Visible = True
Me.Tool_CostEuro.Visible = False
Me.Tool_CostGBP.Visible = False
Me.TxtToolingAvail.Visible = False
Else
Me.TxtToolingAvail.Visible = True
Me.Tool_CostDollar.Visible = False
Me.Tool_CostEuro.Visible = False
Me.Tool_CostGBP.Visible = False

End If
End If
End If
End Sub

If its a macro you are using, then it would be SetValue while using the
conditions??

PS I'm no expert but I hope this helps

" wrote:

How to show or hide an image or a text box connected to a iif condition
???

iif(number=0;image A;imageB)


Thanks - Ciao !


Roberto

On Sat, 18 Feb 2006 08:18:49 +0100, wrote:

How to show or hide an image or a text box connected to a iif condition
???

iif(number=0;image A;imageB)

Thanks - Ciao !

Roberto

If you have the both images already positioned on the report and just
want to show one or the other, code the Format event of the section
(i.e. Detail Format Event) of the report that the images are in:

Me!ImageA.Visible = Me![Number] = 0
Me!ImageB.Visible = Not Me![Number] = 0
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail