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

Jumat, 09 Oktober 2015

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

I would leave the picture loaded in the control at design time and use the Detail Format event to test the value. If ApprovedBy is not Null, then set the Visible property of the control to False to hide it.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Oct 8, 2015, at 11:55 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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

On 10/8/2015 2:11 PM, jcross@crossproducts.plus.com [MS_Access_Professionals] wrote:

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