Show Label if ..

[fenhow]

Is there any way to have a label show on a report only if one of the txt boxes has a particlar value in it?

Say I have a label "Sign Here _______" and I only want this to show on the report if txtName has Bob in it otherwise the label sign here is invisible.

Thanks.

Fen How

 

[ajetrumpet]

Is there any way to have a label show on a report only if one of the txt boxes has a particlar value in it?

Say I have a label "Sign Here _______" and I only want this to show on the report if txtName has Bob in it otherwise the label sign here is invisible.

Thanks.

Fen How

if me.textbox = "Bob" then
me.label.visible = true
else
me.label.visible = false

 

[fenhow]

Thanks, that looks great. Where do I put that code?

Thanks.

Fen

 

[ajetrumpet]

put it on the LOAD() event of the form. that should be fine.