I would like to hide a label if a result in a text box is = "1". I thought I could do this via the conditional formatting but looks like I can't add that to a label. Any ideas or alteratives?

Thanks for any help!

Use the On Format event of the section where the label resides ...

Me.LabelName.Visible = Me.TextboxName <> 1

RDH

If Me.YourTextBox = "1" Then
Me.YourLabel.Visible = False
Else
Me.YourLabel.Visible = True
End If

You may have to play with what event this is associated with on a report.

Hi,
use the forms on current event or whatever other event you want:

If Me.YourControl.Value = 1 Then
Me.YourLable.Visible = False
Else
Me.YourLabel.Vlisible = True
End If

HTH
Good luck

Opps...just saw that this is report related so use either ricky's method or add an event to the details section.

Toggle a Boolean vaule with another Boolean value ...
No need for the If/Else/End If ...

RDH

Again .. no need for the If/Else/End If ...

RDH

I know that method is possible, but I just never find myself using it!
Maybe I have too much time on mind hand to write out the whole if then else

LOL ... this method is overlooked my many people ...

RDH

"overlooked" or ignored?

Could be either .. I suspect ..

RDH

I posted it that way because there are some 'unknowns' in the OPs question. It was never stated whether the textbox is a string or a value, or what the other possibilities of the textbox could be.

But you're right. It can be done more efficiently if certain things are true. Personally, I would use a hidden checkbox to negate the need for the "<>".

Well...I'm glad we discussed this
Happy Holidays!

I can't agree to that solution ..
Even if the value is a string .. it can easily be converted to a numeric value or alter the expression to handle the string value ...

Me.LabelName.Visible = Me.TextboxName <> "1"

RDH

Edited by: R. Hicks on Mon Dec 19 11:17:57 EST 2005.

LOL ...

RDH

I still think there are too many unknows to make a definitive statement as to which method is more efficient. Is the textbox on a bound or unbound form? Can the textbox value itself be rewritten to allow for more reliable code? Is the checkbox's only purpose to toggle the label?

I hate nitpicking on threads like this. My only point was we didn't have enough info to agree. Given the full circumstance, we would probably come to the same conclusion.

Nothing "nitpicking" about this ... and I find your reply somewhat hostile ...
You should not post a reply if you don't want anyone to post a more efficient and shorter solution.
There is no need to use an If/Else/End If that requires a boolean output when evaluating 2 boolean values ...

RDH

Ricky, I didn't mean to come across as hostile, and do apologize for that. Evaluating boolean to boolean is definately more efficient. We can both agree to that. If I sounded like this was the intent of my reply, I did not mean it to be.

What it was meant to say was there may be other ways to further improve the efficiency if more details were provided.

Hope I didn't overstep anything, here. It certainly wasn't my intent. I also hope the original poster was not offended by our conversation. Nor was it my intent to infer that they did anything wrong.

Again, I apologize.

Had me worried there for a second ...

Of couse the If/Else/End If solution will return the same result .. my point was only that it is not needed in this case.
We are here to provide correct solutions to problems being posted .. and in this case .. both solutions are correct and acceptable.
I just think that the shorter, less coding solution would be better.

RDH

I agree.

I thought this was concerning a report issue?

It was never stated where the textbox was.

Well..but the thread is in the reports forum so I would assume it is on a report!

It may be...

Thanks everyone for the great info & interested discussion! To answer one question, the text box is located on a report not a form.

I went with this option:



This works great! Now I'm trying to hide two labels if the same text box in question is = "2". I'm trying to figure out how to add two labels to the same "If" line? So basically to add to what I already have, would I do something like this??:

Try using a Case Select statement ..
You can then use as many variables as ytou want by add a "Case" ...

Note .. The above example is assuming that "Me.txtType" is returning a numeric value

RDH

Thanks! What if I have a text value? I have 2 reports that I want to use this with, one returns a numeric & the other returns text.

Thanks again!!!

If the value being evaluated is a string (text) .. them enclose the values to evaluate within quotes.

Here is the same example as a text variable:

This should show you the difference ...

RDH

Thanks so much!!! This works great.

No problem .. you are welcome ..

RDH

After playing with this more I am wondering if it is possible to do this- When txtType is = 1 hide lblCPR but SHOW ALL OTHER LABELS (lbl10 and lbl30) and when txtType is = 2 hide lblCPR but SHOW lbl10 and lbl30. Is this possible?

Try ....

RDH

Once again my friend...

Works great! Thanks so much & Happy Holidays!!!

And ... Happy Holidays to you ..

RDH

I am loving this feature where I can hide a label if the text box doesn't meet a certain criteria!

Right now I have a report that the text box is sometimes empty or Null. I wrote this:



But I'm getting an error with the "". I thought this meant the same as Is Null ???

No it means a zero length string. There is a difference between that and isnull!
Have a look at this earlier discussion!
There are many ways to ensure a control is actual NULL.
HTH
Good luck

Thanks! I'm not getting an error now but it's not working... ????

Aren't you missing the else part?
HTH
Good luck

Yeah you are right! SHEESH!!!

But now I'm getting a compile error saying:



ARG!!! (by the way, I renamed my labels and text boxes.)

Thanks for your help man!!!!!!

Try to move Me.lblPager.Visible = False on a new line:

If Nz(Me.txtPMPager.Value, "") = "" Then
Me.lblPager.Visible = False
Else
Me.lblPager.Visible = True
End If

Also make sure you have no other if statements anymore anywhere.
HTH
Good luck

I also want to add another label and text box to this. Would I write it like this?

No you need to evaluate this seperatly:

If Nz(Me.txtPMPager, "") = "" OR Nz(Me.txtSuperPager, "") Then
Me.lblPager.Visible = False
Me.lblPagerSupers.Visible = False
Else
Me.lblPager.Visible = True
Me.lblPagerSupers.Visible = True
End If

HTH
Good luck

I'm not receiving an error now but it's not working.
I'm sorry to bother you so much with this!!!

There is no more if statements at all in this report. Here is EVERYTHING that is in my report:

Is txtPMPager really Null or empty?
It should work as the code seems to be correct if your controls are the names you assigned there.
HTH
Good luck

Now I'm getting an error when I try to view the report saying: Run-time error '13': Type MisMatch

Basically not all of our PM's have pager's so sometimes the textbox will have the pager number in it and other times it will not. Does that make sense??