Hi,
I have an Access 97 report that mimics an official UK Covernment
Customs document, with Page Headers and Footers presenting static data
for each page (logos etc). The report is made up (typically) of
several lines of detail data, with a few summary lines at the foot of
these. I am (nearly) achieving the right "look and feel" by presenting
the line items in the Report Detail section and the summary lines in
the Report Footer BUT...
....the "real thing" has vertical lines running down the body of the
document. I have managed to programatically replicate these by using
me.Line in the respective onFormat events of the Detail and Report
Footer, EXCEPT for a problem with the last page.
If there are only one or two detail items on the last page, then the
Report Footer follows immediately on (as I want), but there is then a
big space between the bottom of the Report Footer and the final page
footer, completely ruining the effect that I am seeking.
What I want to be able to do is grow the Report Footer so that it
fills this "white space". If I can do this, then hopefully I can
"draw" lines within the Report Footer down to the final Page Footer
and the net result will look like the real document - rather than the
unusable mess that it currently is !
Any help/guidance would be appreciated.
TIA
Martin 2 4059
Have a look at the older non class based solutions here: http://www.lebans.com/PrintLines.htm
If I remember correctly you would use the Line method in the Page event
for the last page.
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Martin" <ma************ *@dana.com> wrote in message
news:af******** *************** **@posting.goog le.com... Hi,
I have an Access 97 report that mimics an official UK Covernment Customs document, with Page Headers and Footers presenting static data for each page (logos etc). The report is made up (typically) of several lines of detail data, with a few summary lines at the foot of these. I am (nearly) achieving the right "look and feel" by presenting the line items in the Report Detail section and the summary lines in the Report Footer BUT...
...the "real thing" has vertical lines running down the body of the document. I have managed to programatically replicate these by using me.Line in the respective onFormat events of the Detail and Report Footer, EXCEPT for a problem with the last page.
If there are only one or two detail items on the last page, then the Report Footer follows immediately on (as I want), but there is then a big space between the bottom of the Report Footer and the final page footer, completely ruining the effect that I am seeking.
What I want to be able to do is grow the Report Footer so that it fills this "white space". If I can do this, then hopefully I can "draw" lines within the Report Footer down to the final Page Footer and the net result will look like the real document - rather than the unusable mess that it currently is !
Any help/guidance would be appreciated.
TIA
Martin
Stephen,
Thanks, it worked just fine (great website, too !).
For the benefit of anybody else who may be following this thread, what
I did was include the following code(simplified to show just one
vertical line being drawn) in the On Page event of the REPORT:-
With Me
.ScaleMode = 1
.ForeColor = 0 ' 0=Black,
' Measurement is in twips
' 1 * 1440 represents 1 inch; 1 * 567 represents 1 cm
Me.Line (2.778 * 567, .Section(acPage Header).Height)- _
(2.778 * 567, .ScaleHeight - (.Section(acPag eFooter).Height ))
End with
This draws a line on EVERY page 2.778 cm in from the left-hand margin,
stretching from the PageHeader to the PageFooter - exactly what I was
trying to achieve. The beauty of this code is that I then did not have
to worry about drawing lines in either the Detail or Report Footer
sections.
Thanks once again.
Martin
_________
"Stephen Lebans" <Fo************ *************** *************@l invalid.com> wrote in message news:<gW******* **************@ ursa-nb00s0.nbnet.nb .ca>... Have a look at the older non class based solutions here: http://www.lebans.com/PrintLines.htm
If I remember correctly you would use the Line method in the Page event for the last page. --
HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
"Martin" <ma************ *@dana.com> wrote in message news:af******** *************** **@posting.goog le.com... Hi,
I have an Access 97 report that mimics an official UK Covernment Customs document, with Page Headers and Footers presenting static data for each page (logos etc). The report is made up (typically) of several lines of detail data, with a few summary lines at the foot of these. I am (nearly) achieving the right "look and feel" by presenting the line items in the Report Detail section and the summary lines in the Report Footer BUT...
...the "real thing" has vertical lines running down the body of the document. I have managed to programatically replicate these by using me.Line in the respective onFormat events of the Detail and Report Footer, EXCEPT for a problem with the last page.
If there are only one or two detail items on the last page, then the Report Footer follows immediately on (as I want), but there is then a big space between the bottom of the Report Footer and the final page footer, completely ruining the effect that I am seeking.
What I want to be able to do is grow the Report Footer so that it fills this "white space". If I can do this, then hopefully I can "draw" lines within the Report Footer down to the final Page Footer and the net result will look like the real document - rather than the unusable mess that it currently is !
Any help/guidance would be appreciated.
TIA
Martin This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Baker |
last post by:
Hi:
Stuck on another thing.
On a report I am creating, I want to make the detail section one line vertically. However,
in design view, I click on the page Footer Bar ,grab it with the "double arrow and
cross", and try to move it up and while it moves, as soon as I release it jumps back to
its original position. For some reason the...
|
by: Bill Short |
last post by:
I have a subreport in the detail section of the main report. The
subreport is set to CanGrow. I am using the Me.Line method (thanks to
Stephen Lebans) to create vertical lines that fill in between bottom
of the subreport and the top of the footer section. I have this code
working with the one problem. When I open the detail section up to...
|
by: ALESSANDRO Baraldi |
last post by:
Hi and Good Sunday.
Have i any way to Reduce at Runtime, with
no change on Design View, the Height property
of Detail_Section on my Report.....?
The Section Property is Read_Only but if
i encrease one Control inside with
ctl.Height>Section.Height
automatically the Section adapt the Height
|
by: Trevor Best |
last post by:
I have a report that's fairly simple, page headers and footers, detail
has a subreport in (can vary in length). The customer wanted a signature
block for them, their client and 3rd party. This was no problem, couple
of boxes and labels in the report footer.
Now customer wants this signature block on the foot of page 1 (stoopid
IMO as that...
|
by: terragrub |
last post by:
I found some code that works great to creat empty rows of boxes on a
report from the end of the data to the bottom of the report. Now, I
can't seem to find the original message to post a question on that
thread.
The code is as follows.
In the Report OnFormat section the I use the
following.
Private Sub Report_Page()
| |
by: jess |
last post by:
Hi,
Im using the following code to make a new report based on an existing
report.
Set rpt = CreateReport(, "_SemiAnnualMaster")
The problem that I am running into is that none of the report controls
are coming across. All I end up with is a blank report. So, I manually
copied all the Labels, Text boxes etc across..
|
by: Greg |
last post by:
Most suggestions on this topic recommend to use a page footer and make
it visible only on the last page. My problem is that the footer is half
of the height of a page which means the detail would show on only the
top half of each page with whitepace at the bottom of each page.
How can I get the detail to fill each page with my "half page...
|
by: Daniele |
last post by:
I have to create a report, that contains in the section body a list of
record.
For every record it has to appear an incremental additional field that
begins from One; when he reaches the record 50, it is had to activate a page
break and the following record leaves again with numeration equal to one.
How can I do?
|
by: NJonge01 |
last post by:
Hi,
I'd like to produce a report that basically looks like an excel printout.
Description:
Profile Print Report
Detail Section with 3 bordered text boxes
all text boxes are 'abutted' against each other (where one ends, the next begins)
all text boxes have the 'can grow' property set to yes.
Detail Section with 'can grown' = yes
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |