Hide Control in Report Page Header 1

[TimTDP]

How do I hide a control in a report's page header if the value of the controls = a criterea?

I have tried:

dim WClause as string

WClause = "NoShow"

if me.strCustomer = "NoShow" Then
me.strCustomer.Visible = True
Else
me.strCustomer.Visible = False
End If

but strCustomer does not like the attribute .visible!

Many thanks

 

[Lilliabeth]

I just copied your code and it worked fine for me as it is, but it really is overkill for what you need to do - you do not need to declare a variable. Having said that, you should make sure to rename your form controls so they don't have the same name as the fields. It seemed to me you asked to turn off visibility if a criteria is true, then your example turned it on if the criteria was true. If the following does the opposite of what you want, get rid of the Not.

Me.txtCustomer.Visible = Not (Me.txtCustomer.Value = "No Show")

 

[TimTDP]

I still can't get it to work!

Where did you place your code?