Hi there,
I'm encountering an inexplicable problem with page formatting in
reports. Here's the easiest way to explain it:
The Detail section of my report contains two elements:
[unbound text box]
[DatabaseField]
And let's say I have the following VB code for the Detail_Format
event:
Me![unbound text box] = Me![unbound text box] + 1
The output of the report looks like this:
1
data item one
2
data item two
3
data item three
4
data item four
and so on...
This works fine unless a page break is encountered, in which case the
result actually looks like this:
1
data item one
2
data item two
3
data item three
---------Access inserts page break here--------
5
data item four
Apparently, Access "skips" a Detail_Format event. I've tried to trace
this and it appears that Access issues two Detail_Format events every
time it issues one Report_Page event, but somehow suppresses or
ignores the results from the first format event.
Has anyone else encountered this, and do you have any suggestions for
dealing with it?
Many thanks in advance for your wisdom,
-Eddy Bee
P.S. By the way, if I use Running Sum in the above example, it does
work correctly with page breaks. Unfortunately, the above example is
merely a simplified explanation of the problem - the actual formatting
requirements for my code are considerably more involved.