troubleshooting Question

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

Avatar of Rob4077
Rob4077Flag for Australia asked on
Microsoft Access
4 Comments1 Solution308 ViewsLast Modified:
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?
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros