[MS_AccessPros] Re: Switching a report watermark on/off

 

Thanks Crystal & John. Couldn't get either to work. However after trawling the net I found a post by AJ Tejpal which does work. I kept the code in the Page header format, but when it needs 'turning off' you need to set the picture property to a 'blank' graphic file. Apparently only changing it to another graphic file will change it. So now my code is:

Dim draft as string

If IsNull(Me!ApprovedBy) Then

   draft = "C:\Databases\draft.jpg"

Else

   draft = "C:\Databases\blank.jpg"

End If

Me.Picture = draft

Thanks for your help.

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 (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___