Conditional Field - Print/Don't Print

[whitjl143]

I have a field in the detail section that I want to print when the value of
another field is "Yes". This code works on the field itself but does not
hide/unhide the Label of the field.

If Me.Revised = "Yes" Then
Me.RevisedDate.Visible = False
Else
Me.RevisedDate.Visible = True
End If

Any suggestions?

 

[fredg]

I have a field in the detail section that I want to print when the value of
another field is "Yes". This code works on the field itself but does not
hide/unhide the Label of the field.

If Me.Revised = "Yes" Then
Me.RevisedDate.Visible = False
Else
Me.RevisedDate.Visible = True
End If

Any suggestions?

And the name of that label is?

Let's make sure I have your logic right.
If [Revised] is Yes you DO NOT wish to show the [RevisedDate] nor it's
Label, otherwise show them. Correct?

If [Revised] is a TExt datatype field:

Me.[RevisedDate].Visible = Not Me.[Revised] = "Yes"
Me.[RevisedDateLabelName].Visible = Not Me.[Revised] = "Yes"

If [Revised] IS a check box field:

Me.[RevisedDate].Visible = Not Me.[Revised]
Me.[RevisedDateLabelName].Visible = Not Me.[Revised]