By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a

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 discussion thread is closed

Replies have been disabled for this discussion.