[MS_AccessPros] Switching a report watermark on/off

 

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: jcross@crossproducts.plus.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___