Suppress Label

[Dorothy]

Previously I asked how to suppress a field (DateSent)
depending on what was displayed in another field(Status).
I was told to do the following:

=IIf([Status]="Approved",[DateSent],"")

Now I also need to know how to suppress the label of the

 

[fredg]

Previously I asked how to suppress a field (DateSent)
depending on what was displayed in another field(Status).
I was told to do the following:

=IIf([Status]="Approved",[DateSent],"")

Now I also need to know how to suppress the label of the

If the label is in the Report's Detail Section:
Code the Detail Format event:
[LabelName].Visible = [Status] = "Approved"

 

[Dorothy]

Fred, this is not working. Here is what I have:

Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)
LblDateSent.Visible = [Status] = "Approved"
End Sub
What am I doing wrong? You are always so helpful. Thanks
in advance.

-----Original Message-----

Previously I asked how to suppress a field (DateSent)
depending on what was displayed in another field (Status).
I was told to do the following:

=IIf([Status]="Approved",[DateSent],"")

Now I also need to know how to suppress the label of the
DateSent field if the Status field <>Approved. Any help
is greatly appreciated.

If the label is in the Report's Detail Section:
Code the Detail Format event:
[LabelName].Visible = [Status] = "Approved"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[Dorothy]

-----Original Message-----

Previously I asked how to suppress a field (DateSent)
depending on what was displayed in another field (Status).
I was told to do the following:

=IIf([Status]="Approved",[DateSent],"")

Now I also need to know how to suppress the label of the
DateSent field if the Status field <>Approved. Any help
is greatly appreciated.

If the label is in the Report's Detail Section:
Code the Detail Format event:
[LabelName].Visible = [Status] = "Approved"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Sorry Fred, my error (isn't that usually the case) it is

working. Thanks so much.