473,383 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Is It possible to anchor thr Report Footer to the bottom of the page?

RobH
56
I have a report (a quotation) which has included in the Report Footer a copy of "terms and Conditions" and a bank deposit slip - With the aim the customer can take the quote to the bank and make a deposit over the bank counter.

The Deposit Slip needs to remain at the bottom of the page so that its easy for the bank to remove the deposit slip component.

As I have subForms in the middle of the report with CanGrow & CanShrik set to yes I am finding that the Report footer moves according to the content on the page.

How can I force the Report Footer to appear at the bottom of the page?
Sep 22 '07 #1
4 5641
BradHodge
166 Expert 100+
I have a report (a quotation) which has included in the Report Footer a copy of "terms and Conditions" and a bank deposit slip - With the aim the customer can take the quote to the bank and make a deposit over the bank counter.

The Deposit Slip needs to remain at the bottom of the page so that its easy for the bank to remove the deposit slip component.

As I have subForms in the middle of the report with CanGrow & CanShrik set to yes I am finding that the Report footer moves according to the content on the page.

How can I force the Report Footer to appear at the bottom of the page?
Rob,

Try putting your quote in the Page Footer instead. This will force it to be at the bottom of the page.

Brad.
Sep 22 '07 #2
RobH
56
Rob,

Try putting your quote in the Page Footer instead. This will force it to be at the bottom of the page.

Brad.

Problem is the Quote can go over two pages. They dont need the deposit slip & terms&Conditions on each page.
Sep 22 '07 #3
NeoPa
32,556 Expert Mod 16PB
I don't think there is Rob, I'm afraid.
You could try playing with the Page Format &/or Print events to see if you could amend things on the fly, but I see no option to anchor the Report Footer section (except to the top of the page).
I would look at an empty (&/or hidden) Label control (or TextBox) and see if I couldn't change its status or contents at Format / Print time to display what you need.
Sep 22 '07 #4
barry07
47
One thing you can do is put the deposit slip in the page footer and hide it if page number is greater than one. The only snag is the subsequent pages will have a blank area of the same size in the footer. (I tried varying the PageFooter height dynamically, but it doesn't seem to work).

This is the code assuming the Deposit Slip is a single label - if this is not the case you can enclose it in a group and make the group invisible in the same way

Expand|Select|Wrap|Line Numbers
  1. Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
  2. If Page > 1 Then
  3.     Label1.Visible = False
  4. Else
  5.     Label1.Visible = True
  6. End If
  7. End Sub
Sep 24 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Martin | last post by:
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...
1
by: Karen | last post by:
I am trying to create an invoice that looks similar to the Peachtree invoice. I set up the page header and detail, but I can't figure out how to make the totals print at the bottom of the page. I...
2
by: DFS | last post by:
Main report contains one large graph in the detail band (no detail records). Subreport snakes just fine (5 columns) when opening by itself. When I add it to the main report (in the report...
2
by: report help | last post by:
I have a report that is supposed to be two pages. The first page should contain the header, some data from a query, and the footer. The second page should contain the header, two subreports, and...
6
by: leemansiuk | last post by:
hi all, i am quite new to access and have come stuck on quite a simple problem (i think). i have created a report which list items from an orders table etc.. as the report could grow (listing...
0
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...
13
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...
3
by: fonzie | last post by:
On my report I am currently using page footer to display some disclaimer information. No matter how many records show up in the detail section, the page footer is always at the bottom of the page....
8
by: azjudd | last post by:
Thank you in advance for your help on this one. I'm using named anchor tags on a FAQ page with questions listed at the top and answers below; a standard jump-to feature. However, anytime an anchor...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.