Conditional Field - Print/Don't Print

  • Thread starter Thread starter whitjl143
  • Start date Start date
W

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



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