473,394 Members | 2,052 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,394 software developers and data experts.

Report: Text box won't print or repeat in page header.

Hello all,

I have a text box in the page header of my Access report that takes a
dynamic string value from a named text box on an open form as its
control source, written as follows:

=Forms!frmExtractResInfo!txtSelectionCriteria

Two problems/situations occur:

1) It previews OK, but it isn't present when printing to hardcopy or a
..pdf file.

2) The text box is in the "page header" portion of the report, yet
only shows up on the first page. Everything else in this portion of
the report displays/prints to each page just fine.

I'm pulling my hair out trying to figure out why this text box won't
output. Any ideas!
Thanks for the help,

-Nate

Access 2003
Windows XP

Nov 13 '05 #1
3 6030
Try using the Report's OpenArgs property to pass the value to the report ...

Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

"akparasite" <oa**********@centurytel.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello all,

I have a text box in the page header of my Access report that takes a
dynamic string value from a named text box on an open form as its
control source, written as follows:

=Forms!frmExtractResInfo!txtSelectionCriteria

Two problems/situations occur:

1) It previews OK, but it isn't present when printing to hardcopy or a
.pdf file.

2) The text box is in the "page header" portion of the report, yet
only shows up on the first page. Everything else in this portion of
the report displays/prints to each page just fine.

I'm pulling my hair out trying to figure out why this text box won't
output. Any ideas!
Thanks for the help,

-Nate

Access 2003
Windows XP

Nov 13 '05 #2
Thanks for the reply Tony. I feel pretty boneheaded, but found the
problem. I have a for/next statement that clears control types on the
form once search criteria for a report is submitted. It didn't occur
to me until just now that I was clearing my hidden text box containing
the search submission statement as well.

Thanks for the quick reply!

-Nate

Tony D'Ambra wrote:
Try using the Report's OpenArgs property to pass the value to the report ...
Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

"akparasite" <oa**********@centurytel.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello all,

I have a text box in the page header of my Access report that takes a dynamic string value from a named text box on an open form as its
control source, written as follows:

=Forms!frmExtractResInfo!txtSelectionCriteria

Two problems/situations occur:

1) It previews OK, but it isn't present when printing to hardcopy or a .pdf file.

2) The text box is in the "page header" portion of the report, yet
only shows up on the first page. Everything else in this portion of the report displays/prints to each page just fine.

I'm pulling my hair out trying to figure out why this text box won't output. Any ideas!
Thanks for the help,

-Nate

Access 2003
Windows XP


Nov 13 '05 #3

Tony D'Ambra wrote:
Try using the Report's OpenArgs property to pass the value to the report ...
Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

"akparasite" <oa**********@centurytel.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello all,

I have a text box in the page header of my Access report that takes a dynamic string value from a named text box on an open form as its
control source, written as follows:

=Forms!frmExtractResInfo!txtSelectionCriteria

Two problems/situations occur:

1) It previews OK, but it isn't present when printing to hardcopy or a .pdf file.

2) The text box is in the "page header" portion of the report, yet
only shows up on the first page. Everything else in this portion of the report displays/prints to each page just fine.

I'm pulling my hair out trying to figure out why this text box won't output. Any ideas!
Thanks for the help,

-Nate

Access 2003
Windows XP


Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to...
6
by: Melissa | last post by:
I created a report that has labels in the top three inches of the page header. There's also an unbound subform there. When I go to preview or print, the records from the detail section overlap...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
1
by: pemigh | last post by:
I have a report with pages breaking in the middle of text box controls. And it's not just on a line-by-line basis, but sometimes (in a situation that I can no longer recreate) just the bottom...
3
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
4
by: DavidB | last post by:
Im not sure if I am missing something obvious here or not so excuse me if this is a DFU question please... I have a report I am working on that includes the following data. Agency Name Vendor...
6
by: Eddie | last post by:
Hi all, I am displaying a number of reports, and giving the users an option to display them on the web or download them to Excel. If they want the Excel file, I just use the PHP header command...
12
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to...
1
by: franc sutherland | last post by:
Hi, I am using Access 2003. I have set up an invoice in a report. I have set up the name and address as text boxes in the Page Header which I've made as small as possible then set the Can...
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...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
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...

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.