Heading that remain in Report View of an Access report.

Hey Experts,

I have a client that wants to be able to deal with reports interactively. Meaning to click on a fields on the report and have an event trigger. No problem in Report View, but... report view is very different than print preview. One thing that might be an issue is that as you scroll through the report, you lose your headings. Is there a way in report view to keep the headings.

Thanks in advance.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Well maybe you need a "floating" form that will load along with the report and allow for better interaction...instead of clicking in the report you could click on the form and handle the filters you want...
Report events are only "live" in ReportView and we don't have any way to change the way it works.  I don't like it so I don't use it.  It doesn't support page breaks and therefore, none of the code in the "break" events will run either.  So, you get some ability to interact with data but you loose much of the reporting aspect of a report.

Creating a form doesn't really solve the problem because it also doesn't do break logic unless you make a main form and a subform and then add filters to the main form.

Perhaps giving the user the option of opening the report in PrintPreview or ReportView would be a workable compromise.  That way, depending on what he wants to do, he can choose which format to open.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Hamed NasrRetired IT ProfessionalCommented:
Is there a way in report view to keep the headings.
You may try putting the header in a form that has the report as a subreport.

to click on a fields on the report and have an event trigger
Give an example of what process you need to trigger when clicking a field.
eantarAuthor Commented:
Hi all, I think the best way around this is to use a form / subform that mimics a report. Thanks for your help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.