If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
IIF CONDITION
Not sure how you are doing this but you need commas instead of
semicolons in the IIf statement. |
#3
|
|||
|
|||
IIF CONDITION
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 |
#4
|
|||
|
|||
IIF CONDITION
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
enhanced conditional formatting | Stuart | General Discussion | 13 | November 13th, 2005 07:20 PM |
conditional formatting - multiple condition | jenhow | General Discussion | 5 | August 17th, 2005 02:45 PM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Where condition to collect multiple selected records | Santanu De | Setting Up & Running Reports | 3 | September 30th, 2004 10:19 PM |
Condition 1 OR Condition 2 | Martin | Running & Setting Up Queries | 2 | August 23rd, 2004 03:38 PM |