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

 

you're welcome, Jane -- glad you got it

AD continues to help us!

warm regards,
crystal

Have a suggestion to improve Access?
http://access.uservoice.com/


~ have an awesome day ~

On 10/9/2015 8:04 AM, jcross@crossproducts.plus.com [MS_Access_Professionals] wrote:

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: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___