Report question...

[Guest]

I have a signature on my report that I pasted on my report that is OLE
Unbound. I would like to hide it if a field(EmplName) on the report is not
equal XYZ.

How will I do that

 

[Allen Browne]

In the Format event of the (Detail?) section, add this code to the event
procedure:

Dim bShow As Boolean
bShow = Nz(Me.EmplName = "XYZ", False)
If Me.[Sig].Visible <> bShow Then
Me.[Sig].Visible = bShow
End If

Change "Sig" to the name of your OLE Object control.

 

[Guest]

Thank you so much that helped...

In the Format event of the (Detail?) section, add this code to the event
procedure:

Dim bShow As Boolean
bShow = Nz(Me.EmplName = "XYZ", False)
If Me.[Sig].Visible <> bShow Then
Me.[Sig].Visible = bShow
End If

Change "Sig" to the name of your OLE Object control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a signature on my report that I pasted on my report that is OLE
Unbound. I would like to hide it if a field(EmplName) on the report is
not
equal XYZ.

How will I do that