Connecting Tech Pros Worldwide Forums | Help | Site Map

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

akparasite
Guest
 
Posts: n/a
#1: Nov 13 '05
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


Tony D'Ambra
Guest
 
Posts: n/a
#2: Nov 13 '05

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


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" <oasisbigfork@centurytel.net> wrote in message
news:1102977906.925492.232430@f14g2000cwb.googlegr oups.com...[color=blue]
> 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
>[/color]


akparasite
Guest
 
Posts: n/a
#3: Nov 13 '05

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


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:[color=blue]
> Try using the Report's OpenArgs property to pass the value to the[/color]
report ...[color=blue]
>
> Tony D'Ambra
> Web Site: aadconsulting.com
> Web Blog: accessextra.net
>
> "akparasite" <oasisbigfork@centurytel.net> wrote in message
> news:1102977906.925492.232430@f14g2000cwb.googlegr oups.com...[color=green]
> > Hello all,
> >
> > I have a text box in the page header of my Access report that takes[/color][/color]
a[color=blue][color=green]
> > 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[/color][/color]
or a[color=blue][color=green]
> > .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[/color][/color]
of[color=blue][color=green]
> > the report displays/prints to each page just fine.
> >
> > I'm pulling my hair out trying to figure out why this text box[/color][/color]
won't[color=blue][color=green]
> > output. Any ideas!
> > Thanks for the help,
> >
> > -Nate
> >
> > Access 2003
> > Windows XP
> >[/color][/color]

akparasite
Guest
 
Posts: n/a
#4: Nov 13 '05

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



Tony D'Ambra wrote:[color=blue]
> Try using the Report's OpenArgs property to pass the value to the[/color]
report ...[color=blue]
>
> Tony D'Ambra
> Web Site: aadconsulting.com
> Web Blog: accessextra.net
>
> "akparasite" <oasisbigfork@centurytel.net> wrote in message
> news:1102977906.925492.232430@f14g2000cwb.googlegr oups.com...[color=green]
> > Hello all,
> >
> > I have a text box in the page header of my Access report that takes[/color][/color]
a[color=blue][color=green]
> > 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[/color][/color]
or a[color=blue][color=green]
> > .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[/color][/color]
of[color=blue][color=green]
> > the report displays/prints to each page just fine.
> >
> > I'm pulling my hair out trying to figure out why this text box[/color][/color]
won't[color=blue][color=green]
> > output. Any ideas!
> > Thanks for the help,
> >
> > -Nate
> >
> > Access 2003
> > Windows XP
> >[/color][/color]

Closed Thread