Problem with a watermark section

  • Thread starter Thread starter Carl Rapson
  • Start date Start date
C

Carl Rapson

I want to add a watermark to my report, so I created a report section by
defining a new Group with the expression '=1' and Group Header = Yes. I put
my watermark fields in the section header, and I put the line

Me.MoveLayout = False

in the section Format event. This works for the first page of my report, but
I want to print the watermark on all pages. My problem is, when I set the
Repeat Section property to Yes, my report locks up -- in fact, Access itself
is completely locked up and I have to kill the process (which is using all
of the CPU). I put a breakpoint on the MoveLayout statement, and it appears
that there is some kind of endless loop that is constantly calling the
watermark section Format event.

My report is based on a single record from the database and contains no
other Sorting or Grouping sections. The report also contains several
embedded subreports. Does anyone have any ideas about what the problem might
be?

Thanks for any information,

Carl Rapson
 
Yes, that works, thanks. I guess I'll go with that method.

I was trying the 'report section' method because some posts I've seen
recommended that over the Picture method. Plus, it should work, and I'm
wondering why it doesn't. Is there any difference between the two methods,
from a resource or performance standpoint?

Carl Rapson
 
The advantage of the Picture is that it makes it dead easy to have the
sections print on top of the graphic, positioning the graphic absolutely on
the page, while still growing/shrinking sections as needed.

I do have a dim recollection regarding a memory leak in earlier versions of
Access where you used the Picture property of a form or report: perhaps that
is what you are asking about? I've no idea whether this has been fixed, but
it should not be an issue unless you are opening the report hundreds of
times in a session. It's certainly the normal approach I use for showing
company logo/letterheads on reports.
 
Sorry it took me so long to respond, I "lost" this thread.

Yes, I'm using both [Page] and [Pages] in the PageHeader section. I have a
text box with the Control Source set to:

="Page " & [Page] & " of " & [Pages]

Carl Rapson

Duane Hookom said:
Are you using any [Page] or [Pages] in your report?

--
Duane Hookom
MS Access MVP


Carl Rapson said:
Yes, that works, thanks. I guess I'll go with that method.

I was trying the 'report section' method because some posts I've seen
recommended that over the Picture method. Plus, it should work, and I'm
wondering why it doesn't. Is there any difference between the two methods,
from a resource or performance standpoint?

Carl Rapson
Click to expand...
Click to expand...
 
What happens if you remove either both or at least [Pages]?

--
Duane Hookom
MS Access MVP


Carl Rapson said:
Sorry it took me so long to respond, I "lost" this thread.

Yes, I'm using both [Page] and [Pages] in the PageHeader section. I have a
text box with the Control Source set to:

="Page " & [Page] & " of " & [Pages]

Carl Rapson

Duane Hookom said:
Are you using any [Page] or [Pages] in your report?

--
Duane Hookom
MS Access MVP


Carl Rapson said:
Yes, that works, thanks. I guess I'll go with that method.

I was trying the 'report section' method because some posts I've seen
recommended that over the Picture method. Plus, it should work, and I'm
wondering why it doesn't. Is there any difference between the two
methods,
from a resource or performance standpoint?

Carl Rapson

Could you create the watermark by just setting the Picture property of
the report?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I want to add a watermark to my report, so I created a report section
by
defining a new Group with the expression '=1' and Group Header = Yes.
I
put my watermark fields in the section header, and I put the line

Me.MoveLayout = False

in the section Format event. This works for the first page of my
report,
but I want to print the watermark on all pages. My problem is, when I
set the Repeat Section property to Yes, my report locks up -- in
fact,
Access itself is completely locked up and I have to kill the process
(which is using all of the CPU). I put a breakpoint on the MoveLayout
statement, and it appears that there is some kind of endless loop
that
is constantly calling the watermark section Format event.

My report is based on a single record from the database and contains
no
other Sorting or Grouping sections. The report also contains several
embedded subreports. Does anyone have any ideas about what the
problem
might be?

Thanks for any information,

Carl Rapson
Click to expand...
Click to expand...
Click to expand...
 
When I removed [Page] and [Pages] from my Page header section, things did
change a bit. After about 15 seconds the forms flashed (as if they were
refreshing) and I was able to continue working. But I never did see the
report; the report icon appeared briefly in the task bar at the bottom of
the screen, but the report window never opened. It looks like the report was
cancelling itself for some reason.

Carl Rapson
 
I have no further suggestions other than what I would do:
-play with it
or
-live with it
or
-replace it

--
Duane Hookom
MS Access MVP


Carl Rapson said:
When I removed [Page] and [Pages] from my Page header section, things did
change a bit. After about 15 seconds the forms flashed (as if they were
refreshing) and I was able to continue working. But I never did see the
report; the report icon appeared briefly in the task bar at the bottom of
the screen, but the report window never opened. It looks like the report
was cancelling itself for some reason.

Carl Rapson

Duane Hookom said:
What happens if you remove either both or at least [Pages]?
Click to expand...
Click to expand...
 
Thanks, I'll probably do a combination of (1) and (3)

Carl

Duane Hookom said:
I have no further suggestions other than what I would do:
-play with it
or
-live with it
or
-replace it

--
Duane Hookom
MS Access MVP


Carl Rapson said:
When I removed [Page] and [Pages] from my Page header section, things did
change a bit. After about 15 seconds the forms flashed (as if they were
refreshing) and I was able to continue working. But I never did see the
report; the report icon appeared briefly in the task bar at the bottom of
the screen, but the report window never opened. It looks like the report
was cancelling itself for some reason.

Carl Rapson

Duane Hookom said:
What happens if you remove either both or at least [Pages]?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top