Hiding details in a report..

[BigBlueScreen]

Hi,

Can someone tell me why this won't work..??

=IIf([Make]="2","",(IIf([Item]="Equipment","Deluxe options pack")))

Let me know if you need more info..

Many thanks,

Jd

 

[PaulF]

You don't have a value to enter if the 2nd IIF is false, along with an extra set of parenthesis

=IIf([Make]="2","",(IIf([Item]="Equipment","Deluxe options pack")))

=IIf([Make]="2","",IIf([Item]="Equipment","Deluxe options pack","AddYourFalseValueHere"))

PaulF

 

[BigBlueScreen]

=IIf([Make]="2","",IIf([Item]=" Equipment ","Deluxe options pack",hidden = false))


This is what I'm trying to do..I think somethings missing though.

Any help greatly appreciated..

 

[PaulF]

Are you referring to an unbound Textbox or to the Caption of a label?
The way I read the statement you have is

If [Make] = "2"
or
[Make]<> "2" and [Item]<> "Equipment" then leave the textbox empty

otherwise

if [Make]<> "2" and [Item] = "Equipment" then have the textbox read "Delux options pack"

which could also be stated
=IIF([Make]<>"2", IIF([Item] = "Equipment","Delux Option Pack",""),"")

PaulF

 

[BigBlueScreen]

Hi,

Thanks for trying to help.. this is an unbound text box.
I need the text to visible for Make 2 and invisible for all others(ie 1,3-5). Hope that clarified this alittle more.

 

[PaulF]

If this is only a situation where if [Make] = "2" then display whatever is in the [Item] Field it would be
= IIF([Make] = "2",[Item],"")

however

if it is where [Make] = "2" and [Item] = "Equipment"

Then

= IIF([Make] = "2", IIF([Item] = "Equipment","Delux Option Pack",""),"")

PaulF

 

[BigBlueScreen]

Hi,

This is the situation.. Makes are defined in a table; 1-5.. Equipment = a check box setup in which all machines and options are listed; (you could choose the machine with or with out options). If you choose a machine you will have pop up on the report a header Equipment; under which all included equipment for all machines resides. Now that you know the scenario.. Any ideas??

 

[PaulF]

Sorry but my brain doesn't seem to want to engage this morning.

Are you working with a Report or Form? You mention a Header on a report, but I thought you were wanting to populate an unbound textbox on a form.

Are you wanting to populate a textbox, or make a Report's Header Visible if a condition is met, and Not Visible if it isn't?

If someone else has a handle on this maybe they can jump in and take over.

Sorry.
PaulF

 

[BigBlueScreen]

Hi,

This is a unbound textbox in the detail section of the report..which I want to make disappear based on condition.

 

[PaulF]

In that case it might be easier to use the OnFormat event for the Detail Section in the Report.


If UnboundTextBoxName = "This" Then
UnboundTextBoxName.Visible = True
Else
UnboundTextBoxName.Visible = False
End If

PaulF