Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old May 16th, 2006, 07:25 AM
scrawford@colonialfirststate.com.au
Guest
 
Posts: n/a
Default Access Report Page Header problem

Hi all,

Does anyone know how I can have a Page Header, but have something
between that and the detail of the report???

ie..

Page Header

Once off piece of text (for the first page only)

Detail...

---NEXT PAGE--

Page Header

Detail...


Regards,

Scott

  #2  
Old May 16th, 2006, 10:25 AM
Andrew R
Guest
 
Posts: n/a
Default Re: Access Report Page Header problem

Hi

I would suggest the following:

As a part of the pager header, put a text box control, the data source
for which is
=IIf([Page]=1,"Your one-off text","")

In this way, although the text box will be a part of every page header,
if it's not page 1, the text box will be empty and thus not visible.

Hope this helps!
Andrew

  #3  
Old May 16th, 2006, 03:55 PM
fredg
Guest
 
Posts: n/a
Default Re: Access Report Page Header problem

On 15 May 2006 23:20:42 -0700, scrawford@colonialfirststate.com.au
wrote:
[color=blue]
> Hi all,
>
> Does anyone know how I can have a Page Header, but have something
> between that and the detail of the report???
>
> ie..
>
> Page Header
>
> Once off piece of text (for the first page only)
>
> Detail...
>
> ---NEXT PAGE--
>
> Page Header
>
> Detail...
>
> Regards,
>
> Scott[/color]

Include the text in the page header.
Code the Page Header Format event:
[ControlWithTextName].Visible = Me.[Page] = 1
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #4  
Old May 16th, 2006, 11:25 PM
Bob Quintal
Guest
 
Posts: n/a
Default Re: Access Report Page Header problem

scrawford@colonialfirststate.com.au wrote in
news:1147760442.513242.154200@v46g2000cwv.googlegr oups.com:
[color=blue]
> Hi all,
>
> Does anyone know how I can have a Page Header, but have
> something between that and the detail of the report???
>
> ie..
>
> Page Header
>
> Once off piece of text (for the first page only)
>
> Detail...
>
> ---NEXT PAGE--
>
> Page Header
>
> Detail...
>
>
> Regards,
>
> Scott
>[/color]

Others have given working suggestions. Another way is to create
a group header. Set the group to a constant. It will only appear
once.

--
Bob Quintal

PA is y I've altered my email address.
  #5  
Old May 17th, 2006, 05:55 AM
scrawford
Guest
 
Posts: n/a
Default Re: Access Report Page Header problem

Thanks for all your help everyone. Extremely helpful.

Cheers,

Scott

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,338 network members.