Prev: Change report layout
Next: Grouping problems with label report
From: PamB on 22 Apr 2010 22:52
Hello everyone,

I have multiple reports that are quite long when viewed on screen. They
print fine, with appropriate 'headings' on each page, but is there any way to
'freeze' the Report Header section and the Page Header section so they remain
visible on screen when scrolling down through the report? (Like 'freeze
panes' in Excel). I'm working with Access 2007.

I have gained a great deal from these newsgroups; I really appreciate the
people who give up their time to answer questions. Thank you in advance for
any response!
--
cheers
pamb
From: Jeff Boyce on 23 Apr 2010 04:58
Pam

If you are trying to do this in a Report, perhaps you need to use another
tool.

Access Reports are used to format data for printing.

If you want to view-on-screen, try using an Access Form. Right off the top
of my head, one way to do something similar to what you describe would be to
use a main form/subform design.

The main form "freezes" the header info, and you scroll through the subform
records to see the various rows.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"PamB" <PamB(a)discussions.microsoft.com> wrote in message
news:74AB27C1-E339-417E-BC5A-F835201406FE(a)microsoft.com...
> Hello everyone,
>
> I have multiple reports that are quite long when viewed on screen. They
> print fine, with appropriate 'headings' on each page, but is there any way
> to
> 'freeze' the Report Header section and the Page Header section so they
> remain
> visible on screen when scrolling down through the report? (Like 'freeze
> panes' in Excel). I'm working with Access 2007.
>
> I have gained a great deal from these newsgroups; I really appreciate the
> people who give up their time to answer questions. Thank you in advance
> for
> any response!
> --
> cheers
> pamb


From: John Spencer on 23 Apr 2010 09:32
I don't even see the need to use a subform. You can have a continuous form
with a form header that contains the portion that you want to freeze and the
detail section would contain the portion you wanted to scroll.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Jeff Boyce wrote:
> Pam
>
> If you are trying to do this in a Report, perhaps you need to use another
> tool.
>
> Access Reports are used to format data for printing.
>
> If you want to view-on-screen, try using an Access Form. Right off the top
> of my head, one way to do something similar to what you describe would be to
> use a main form/subform design.
>
> The main form "freezes" the header info, and you scroll through the subform
> records to see the various rows.
>
> Good luck!
>
 | 
Pages: 1
Prev: Change report layout
Next: Grouping problems with label report