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

Access Report Page Header problem

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

May 16 '06 #1
Share this Question
Share on Google+
4 Replies


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

May 16 '06 #2

P: n/a
On 15 May 2006 23:20:42 -0700, sc*******@colonialfirststate.com.au
wrote:
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


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
May 16 '06 #3

P: n/a
sc*******@colonialfirststate.com.au wrote in
news:11**********************@v46g2000cwv.googlegr oups.com:
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


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.
May 16 '06 #4

P: n/a
Thanks for all your help everyone. Extremely helpful.

Cheers,

Scott

May 17 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.