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

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

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

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.

re: Access Report Page Header problem

Thanks for all your help everyone. Extremely helpful.

Cheers,

Scott