Double line under last record only

[Job]

Any way to do a double line under the last record on a report? or even the
last line on each page page? Many times the footer is too far down from the
last record so it looks out of place to do a line on the footer. I thought
maybe if I had some lines in the detail (though I don't know about double
lines) then set them to visible = false, then when the last record is found
it makes it visible for that record. Just don't know how to do this...

Cheers,

Job

 

[Allen Browne]

For a double-line under the last record in a report, just add 2 lines to the
Report Footer section.

If your report's Detail section is a fixed height, you could conditionally
show the line by calculating how far down the page the report is now, and
making the line visible if this is the last Detail section that will fit.

Actually, there's even a way to fudge that in Access 2000 and later without
code. You can add a text box (not line) to the bottom of your detail
section. Flatten it so it's not very high. Then choose Conditional
Formatting from the Format menu, and set Condition 1 to:
Expression ... [Report].[Top] > 8640
and choose the black color in the Bucket icon.

Note that the Top property is given in twips, where 1440 twips = 1 inch. The
example above therefore shows the box 6 inches down the page. Change the
number to what you need.

 

[Job]

Ok, the Detail section is a fixed height. How would I calculate how far
down the page the report is?
I'll try the other method, but how do I determin whether do use 6 inches or
8 inches? If there are more records then it will be lower, less is higher.
I guess I don't understand the logic. The first solution seems to make more
sense in that you calculate how far down the last visible record is and then
show the line...

Thanks for your help,

Job

For a double-line under the last record in a report, just add 2 lines to
the Report Footer section.

If your report's Detail section is a fixed height, you could conditionally
show the line by calculating how far down the page the report is now, and
making the line visible if this is the last Detail section that will fit.

Actually, there's even a way to fudge that in Access 2000 and later
without code. You can add a text box (not line) to the bottom of your
detail section. Flatten it so it's not very high. Then choose Conditional
Formatting from the Format menu, and set Condition 1 to:
Expression ... [Report].[Top] > 8640
and choose the black color in the Bucket icon.

Note that the Top property is given in twips, where 1440 twips = 1 inch.
The example above therefore shows the box 6 inches down the page. Change
the number to what you need.

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

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

Any way to do a double line under the last record on a report? or even
the last line on each page page? Many times the footer is too far down
from the last record so it looks out of place to do a line on the footer.
I thought maybe if I had some lines in the detail (though I don't know
about double lines) then set them to visible = false, then when the last
record is found it makes it visible for that record. Just don't know how
to do this...

Cheers,

Job

 

[Allen Browne]

The Report Footer is the ideal solution.

The other method is only useful if you want the line immediately under the
last record on *each* page of a multi-page report, without using the Page
Footer (which would be much easier to do.)

You can calculate how far you are down the page if you examine the height of
the Detail section, and measure the height of your paper (e.g. 11 inches =
15840), leaving room for the Page Footer and bottom margin. This is quite
clumsy compared to the Page Footer + Report Footer approach.

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

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

Ok, the Detail section is a fixed height. How would I calculate how far
down the page the report is?
I'll try the other method, but how do I determin whether do use 6 inches
or 8 inches? If there are more records then it will be lower, less is
higher. I guess I don't understand the logic. The first solution seems to
make more sense in that you calculate how far down the last visible record
is and then show the line...

Thanks for your help,

Job

For a double-line under the last record in a report, just add 2 lines to
the Report Footer section.

If your report's Detail section is a fixed height, you could
conditionally show the line by calculating how far down the page the
report is now, and making the line visible if this is the last Detail
section that will fit.

Actually, there's even a way to fudge that in Access 2000 and later
without code. You can add a text box (not line) to the bottom of your
detail section. Flatten it so it's not very high. Then choose Conditional
Formatting from the Format menu, and set Condition 1 to:
Expression ... [Report].[Top] > 8640
and choose the black color in the Bucket icon.

Note that the Top property is given in twips, where 1440 twips = 1 inch.
The example above therefore shows the box 6 inches down the page. Change
the number to what you need.

Any way to do a double line under the last record on a report? or even
the last line on each page page? Many times the footer is too far down
from the last record so it looks out of place to do a line on the
footer. I thought maybe if I had some lines in the detail (though I
don't know about double lines) then set them to visible = false, then
when the last record is found it makes it visible for that record. Just
don't know how to do this...