Avatar of Rob4077
Flag for Australia asked on

Is it possible to freeze the Page Header and/or first column of a Report used as a sub-form?

I have created a small database that imports data from an accounting package and displays results in a specific format. I display the data using a sub-report, rather than sub-form because it easily allows for grouping and sub-totals. I have placed a combo box on the form to enable preliminary data filtering. I am using Access 365, which supports double-click events on a report cell, which I use to facilitate drill downs on the data. I plan on inserting some check boxes on the parent form to allow the user to select which columns to print so the desired result will fit on a single sheet of paper. i can also use the same check boxes to limit the columns displayed on screen if the user has a narrow monitor (e.g. a laptop)

The only drawback is that I haven't figured out how to display the column headers on the sub-report. Once I scroll down the sub-report headers disappear and don't readily come back. I could put them on the form but then I run into issues syncing the form and sub-report if the user scrolls across the page using a narrow screen size. Ideally I would like to lock both the header and a couple of the sub-report columns. Is any of that possible, and if so, how?
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon
Jeffrey Coachman

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.

Hi Jeffrey,

Thanks very much for your comments. You've confirmed what I thought but Experts always amaze me with what you're able to accomplish so I thought it wise to ask. I also hoped that MS may have added some functionality to freeze panes and columns of a report when they introduced the expanded features and I just didn't realise it.

This application is actually best suited to a pivot table but the user is used to an access program I wrote for him 10+ years ago that generated half a dozen reports based on data extracted from his accounting system via an ODBC Link. A recent upgrade of that software meant the link would no longer work so he asked me to find another way of providing the data. This new functionality in MS Access made it very easy to give him a report that  provides the perfect overview - everything he wants to see on one, simple report. And he now has the ability to double-click on a column to open a second report that gives a list of the detailed data that went into the summary overview. So it was too easy and too tempting not to use the report as a quasi-form.

I will do exactly as you suggested - put the headings on the form and give him some pre-formatted, condensed report options to print.

Thanks again for your time and support.

Jeffrey Coachman

but Experts always amaze me with what you're able to accomplish
The old saying is that; anything is possible, ...it all depends on how much time and energy you are willing to spend.

FWIW here is my link of hiding/showing report fields based on check box selections



That's awesome. Thank you so much!!!!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck