How do I make invisible certain information in a text box?

[Guest]

Hi!

Is it possible to make information visible or invisible if a text box in my
report equals a certain value? For example, if the formula in my text box =
100%, I want the names to be visible to print, but if it doesn't, I want the
names hidden. Is there any way to do that?

Thanks in advance!

 

[fredg]

Hi!

Is it possible to make information visible or invisible if a text box in my
report equals a certain value? For example, if the formula in my text box =
100%, I want the names to be visible to print, but if it doesn't, I want the
names hidden. Is there any way to do that?

Thanks in advance!

You could use an unbound text control for this.

=IIf([SomeControl] = 100,[NameField],"")

Or ... you could use code in the detail format event to simply make
the name control visible or not depending upon the value of
[SomeControl]:

Me![NameControl].Visible = [SomeControl] = 100