Hi Jane,
try the Report Load event ... and please let us know if that works
Report Open won't work because data is not yet loaded ... in fact, neither is the report because it can be Cancelled and is not yet the active object
thanks
warm regards,
crystal
~ have an awesome day
Hi
I have a report where I've set the .picture property to a jpg so that it displays 'draft' across the report - like a watermark. That works ok. However I now want it to not appear if the the document has been approved.
I've tried putting the following in the report's On Page, On Open & On PageHeader format & it always appears irrespective of the value of the 'approvedBy' field:
If IsNull(Me!ApprovedBy) Then
Me.Picture = "C:\Databases\draft.jpg"
Else
debug.print "not null"
Me.Picture = ""
End If
Is there some other trick that will switch on/off?
Many thanks
Jane
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar