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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

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
 
Back
Top