One-time set of text boxes UNDER page header?

[Allison]

Access 2003, XP SP 2

I have a report, grouped by alphabet.

I need one set of instructions BELOW the page header, on the first page
only. Same for end of report.

Like this:

{Page Header}

[One-time text on first page only]

{Group Header}

[Detail]

[One-time text on last page only]

{Page Footer}


I tried using {Report Header}, but it prints the Rpt Header first, then the
Page Header and I need it reversed.

Any suggestions?

 

[John Spencer]

Perhaps you can add another group.
Set its field/expression to = 1
Set to have a group header and a group footer and include the one time text
in the group header and group footer.
The group header should print on the first page and the group footer should
print on the last page.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Allison]

Sorry, these are LABELS not text boxes. I apologize for the misinformation.

 

[Allison]

That worked! Thank you kindly.

Perhaps you can add another group.
Set its field/expression to = 1
Set to have a group header and a group footer and include the one time text
in the group header and group footer.
The group header should print on the first page and the group footer should
print on the last page.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Access 2003, XP SP 2

I have a report, grouped by alphabet.

I need one set of instructions BELOW the page header, on the first page
only. Same for end of report.

Like this:

{Page Header}

[One-time text on first page only]

{Group Header}

[Detail]

[One-time text on last page only]

{Page Footer}


I tried using {Report Header}, but it prints the Rpt Header first, then
the
Page Header and I need it reversed.

Any suggestions?

 

[fredg]

Access 2003, XP SP 2

I have a report, grouped by alphabet.

I need one set of instructions BELOW the page header, on the first page
only. Same for end of report.

Like this:

{Page Header}

[One-time text on first page only]

{Group Header}

[Detail]

[One-time text on last page only]

{Page Footer}

I tried using {Report Header}, but it prints the Rpt Header first, then the
Page Header and I need it reversed.

Any suggestions?

Add a control to the report that computes [Pages] (if you don't
already have one, i.e. = "Page " & [Page] & " of " & [Pages]).
You can make it not visible if you don't want to display it.

Add whatever text boxes you need to the top portion of the Group
Header.
Then code the Group Header Format event:
Me.[ControlName1].Visible = Me.[Page] = 1
Me.[ControlName2].Visible = Me.[Page] = 1
etc.

Those controls will only appear on the first page.

Do similar for the Group Footer controls, except this time place the
controls at the bottom portion of the Footer and code the GroupFooter
Format event:

Me.[ControlName1].Visible = Me.[Page] = [Pages]
Me.[ControlName2].Visible = Me.[Page] = [Pages]
etc.

These controls will only appear on the last page group footer.

Set the GroupHeader and GroupFooter CanShrink property to Yes.

 

[Allison]

Thanks Fred. I'm glad you also offered a solution.

Access 2003, XP SP 2

I have a report, grouped by alphabet.

I need one set of instructions BELOW the page header, on the first page
only. Same for end of report.

Like this:

{Page Header}

[One-time text on first page only]

{Group Header}

[Detail]

[One-time text on last page only]

{Page Footer}

I tried using {Report Header}, but it prints the Rpt Header first, then the
Page Header and I need it reversed.

Any suggestions?

Add a control to the report that computes [Pages] (if you don't
already have one, i.e. = "Page " & [Page] & " of " & [Pages]).
You can make it not visible if you don't want to display it.

Add whatever text boxes you need to the top portion of the Group
Header.
Then code the Group Header Format event:
Me.[ControlName1].Visible = Me.[Page] = 1
Me.[ControlName2].Visible = Me.[Page] = 1
etc.

Those controls will only appear on the first page.

Do similar for the Group Footer controls, except this time place the
controls at the bottom portion of the Footer and code the GroupFooter
Format event:

Me.[ControlName1].Visible = Me.[Page] = [Pages]
Me.[ControlName2].Visible = Me.[Page] = [Pages]
etc.

These controls will only appear on the last page group footer.

Set the GroupHeader and GroupFooter CanShrink property to Yes.