If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'Freeze' Report Header and Page Header in screen view - possible?
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 |
#2
|
|||
|
|||
'Freeze' Report Header and Page Header in screen view - possible?
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" wrote in message ... 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 |
#3
|
|||
|
|||
'Freeze' Report Header and Page Header in screen view - possible?
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! |
#4
|
|||
|
|||
'Freeze' Report Header and Page Header in screen view - possib
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... -- cheers pamb "John Spencer" wrote: 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! . |
Thread Tools | |
Display Modes | |
|
|