'Freeze' Report Header and Page Header in screen view - possible?

[PamB]

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!

 

[Jeff Boyce]

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.

 

[John Spencer]

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

 

[PamB]

Thank you both. My preconceived 'idea' of forms as only a means to input data
has now changed. It's a pity I can't group the way I can in the reports, as
this makes my data easier to understand. I am now exploring how to print the
formatted reports from the form with the same data range! Again, thank you
for your direction and for altering the way I think about 'forms'. This has
been of enormous benefit. I have a very long way to go...