Reports

[Mac]

Hello,

I am trying to display a label on my report, however, I only want it visible
a condition is true.

I have a check box field [NOTEligible] and a label on my report [Label25].
Is there a way to make the label visible ONLY if the NOTEligible field = -1?

I have tried a couple of IF...THEN statements in the report On Open event,
but I can an error stating "You entered and exoression that has no value.

Private Sub Report_Open(Cancel As Integer)
If NOTEligible = 0 Then
Label25.Visible = True
Else
Label25.Visible = False
End If

End Sub

I sure could use some help. Thanks.

 

[Douglas J. Steele]

Try putting that code in the Detail_Format rather than Report_Open.

 

[Mac]

Thanks for the response, but I am not sure I understand what you mean. Can
you explain "Detail_Format?"

Thanks!

Try putting that code in the Detail_Format rather than Report_Open.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello,

I am trying to display a label on my report, however, I only want it
visible a condition is true.

I have a check box field [NOTEligible] and a label on my report
[Label25]. Is there a way to make the label visible ONLY if the
NOTEligible field = -1?

I have tried a couple of IF...THEN statements in the report On Open
event, but I can an error stating "You entered and exoression that has no
value.

Private Sub Report_Open(Cancel As Integer)
If NOTEligible = 0 Then
Label25.Visible = True
Else
Label25.Visible = False
End If

End Sub

I sure could use some help. Thanks.

 

[Mac]

I found the Detail_Format that you was talking about. The learning curve
continues.

Try putting that code in the Detail_Format rather than Report_Open.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello,

I am trying to display a label on my report, however, I only want it
visible a condition is true.

I have a check box field [NOTEligible] and a label on my report
[Label25]. Is there a way to make the label visible ONLY if the
NOTEligible field = -1?

I have tried a couple of IF...THEN statements in the report On Open
event, but I can an error stating "You entered and exoression that has no
value.

Private Sub Report_Open(Cancel As Integer)
If NOTEligible = 0 Then
Label25.Visible = True
Else
Label25.Visible = False
End If

End Sub

I sure could use some help. Thanks.